Welcome to WebmasterWorld Guest from 54.161.64.174

Forum Moderators: open

Message Too Old, No Replies

Getting large table into MySQL

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

10+ Year Member



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.

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

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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.
6:57 am on Jan 7, 2007 (gmt 0)

10+ Year Member



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. :)

 

Featured Threads

Hot Threads This Week

Hot Threads This Month