homepage Welcome to WebmasterWorld Guest from 54.161.214.221
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Getting large table into MySQL
mgm_03




msg:3210170
 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




msg:3210894
 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




msg:3211040
 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