49MB .sql -- how do i get it into the DB!!

[torahtrance]

I have an old backup that I need to get a style .xml file from. So i'm trying to use xampp windows ver to make a local site with the backup, but I can't figure out how to add the .sql file that is 49mb when phpmyadmin only allows files 16mb and smaller.

Anyone know a way to do this???

[Brandon Sheley]

break it down ?
copy an past in chunks. stop at the ;

[LICryptkeeper]

hey, I had the same problem (it would timeout) I didnt think of loco's solution, how i ended up doing it was upload the sql via ftp, then ssh'ed into my server and injected it from there. it was the first time i ssh'ed but I caught on within 5 minutes (as long as you remember how to use dos you should be fine)

[Marco van Herwaarden]

No need to use phpMyAdmin on a local install. Install MySQL Administrator (www.mysql.com) and use that to load your backup. Or just use the windows commandline (see instructions on using SSH/Telnet, but just do that from your CMD prompt in windows).

[torahtrance]

from cmd line... very nice ill give it all a try one step at a time!!! thanks guys

**EDIT** about 5% in it says using mysql administrator:
A wrong character set was specified.

and it fails there!

i used the cpanel backup system to backup everything, so I dont know what the problem could be.. is there a way around this?
i clicked ignore errors and build database names that don't exist

[steven s]

<a href="http://www.ozerov.de/bigdump" target="_blank">http://www.ozerov.de/bigdump</a> will break down a sql file into small chunks.

[torahtrance]

*UPDATE* fixed it all!! just set it to do 6000 lines in 1 chunk instead of 10000. excellent

Originally Posted by 1996 328ti

http://www.ozerov.de/bigdump will break down a sql file into small chunks.

Hey this script looks promising, except I just got this random error:
BigDump: Staggered MySQL Dump Importer ver. 0.21b
Processing file: forum_isratrade.sql

Starting at the line: 90001


Fatal error: Maximum execution time of 60 seconds exceeded in C:\Program Files\xampp\htdocs\bigdump.php on line 476

[wtrk]

Originally Posted by 1996 328ti

http://www.ozerov.de/bigdump will break down a sql file into small chunks.

bigdump rocks.

[DaFire]

if you have shell access you can just do

mysql -u<username> -p <dbname> < dumpfile.sql