PGG-Tom

Is it possible to use the mysql LOAD DATA INFILE without the LOCAL option to load text file data from the public side of the site to a mysql table? When I try, I get #1045 - Access denied for user: '*notmyrealuser*@localhost' (Using password: YES) This would be useful. I will be getting 10 to 20 M every week via FTP and it is very slow to download/upload, plus it triples the bandwidth consumed (FTP in, my download, my upload). Your help desk has done a requested large file transfer for me before, but this is something I will need to do every few days. [This is a duplicate of my post on a different forum thread, but it saw no response ...]

Two related questions: 1. Is there a way to transfer 1) a mysql database and 2) a Home Directory between two TCH accounts that does not require me to first download and then upload via my own computer? 2. In uploading files, narrow upload bandwith on my end causes the mysql import to time out before it finishes. I have to break my whole database into maybe 8 subfiles to get it to take on TCH. Is there a way to lengthen the timeout for importing mysql? Thanks.