homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

Getting large table into MySQL

10+ Year Member

Msg#: 3210168 posted 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.



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

Msg#: 3210168 posted 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.


5+ Year Member

Msg#: 3210168 posted 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. :)

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved