Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Getting large table into MySQL

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

Junior Member

10+ Year Member

joined:Aug 4, 2003
votes: 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.

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

Senior Member

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

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

Junior Member

10+ Year Member

joined:May 3, 2005
votes: 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. :)


Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members