I have a database tabel created in MySQL that I need to move to another database. Problem is, the other database does not give me ftp access so I can't just ftp the text file up, then do a Load Data Infile. I need to ftp the file to the web server, and import the data to the MySQL server.
Is this possible? I don't see much in the docs for LOAD DATA INFILE or MYSQLIMPORT that mention remote server import.
Thanks for your help,