Getting large table into MySQL

Forum Moderators: open

Message Too Old, No Replies

Getting large table into MySQL

mgm_03

4:13 am on Jan 6, 2007 (gmt 0)

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.

txbakers

2:29 am on Jan 7, 2007 (gmt 0)

I'd write a PHP routine that will upload it.
OR, perhaps you can do a mySQL dump and FTP the file to the new server, then run the import wizard to get the data in.

piplio

6:57 am on Jan 7, 2007 (gmt 0)

Look into your PHP configuration to increase the limit. Ask your host to do it, or if you have root access, you can do it yourself.

I don't usually like to break things into bits. Not safe... That being said, you gonna do what you gonna do. :)