Import CSV to remote MySQL Database

Anyone who has imported large csv to RDS knows the 1GB limit on the files. The large file will need to be split into portions less than 1GB each, compressed independently and then sent to the server. I assume it would need to be loaded on a new database?

A proposal has not yet been provided

Hi For that large a file, I think I'd rather use a custom made PHP script that would parse all of it and import into a local mysql, then export the dump and import into the remote server, or the php script could run queries directly into the remote server. I'm telling this becuase it depends on how your mysql db is configured and how large are the packets that it accepts. However, as long as you can grant remote access to your mysql, there shouldn't be major issues importing. I'll most likely download the csv locally and run the script locally, on a dev server ... And your job should be completed in about 2-2.5h PS: what MySQL version does your amazon instance run there ? Regards Dragos