I have a 230MB mysql table (620,000 rows) on my local development machine. I want to get it to MySQL on my webhost. I believe there's a 50MB limit to file uploads in phpMyAdmin. So, I could break it into 13 smaller chunks. I could also try using php to loop through the rows and insert them programmatically although the script would probably time out.
My webhost disallows ssh/telnet for security reasons.
When I try writing a LOAD DATA query I get access denied.
Any suggestions are appreciated.