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