If you're having issues importing large sql files into a database via phpmyadmin, I suggest checking out BigDump.

http://www.ozerov.de/bigdump.php

Staggered import of large and very large MySQL Dumps (like phpMyAdmin 2.x Dumps) even through the web servers with hard runtime limit and those in safe mode. The script executes only a small part of the huge dump and restarts itself. The next session starts where the last was stopped.

Why couldn't you have posted this before the weekend? Guess what I spent the weekend doing? Yep trying to import some large sql files via phpmyadmin. I ended up breaking some of the files into smaller files and using the command line for the files I didn't want to break.

Thanks for the link. Looks helpful.

Originally Posted by vangogh

Why couldn't you have posted this before the weekend? Guess what I spent the weekend doing? Yep trying to import some large sql files via phpmyadmin. I ended up breaking some of the files into smaller files and using the command line for the files I didn't want to break.

Thanks for the link. Looks helpful.

Sorry, lol. I never even thought about posting it here until the time I did.

I had to find something since I was reaching maximum execution time provided by my server via phpmyadmin importing my wordpress arcade database (which has quite handful of queries to perform), and found this tool on google search.

Import was pretty much instant with this wonderful, none of this waiting 5 minutes only to have it error out. :P

If you directly try to restore the database from the SQL file using the mysql command prompt, you should be fine with completing the restore/backup process, provided that mysql service does not restart in between.

i will restore this database ,i think it is useful for me in the future,thanks ,if you have another great imformation ,please share it .thanks again

I used BigDump recently to move a sql database to a new server. Slick, easy, and worked like a charm.

Originally Posted by cindyfowler

i will restore this database ,i think it is useful for me in the future,thanks ,if you have another great imformation ,please share it .thanks again

I will don't worry. :P

Originally Posted by ditch182

I used BigDump recently to move a sql database to a new server. Slick, easy, and worked like a charm.

And it's an almost instant dump too.

whats a max size of a SQL file or considered big? 8 MB? I noticed that my backup files grow significantly after every backup (daily)

i think we can open the file and separate it into several smaller files. make sure you do not separate a command into 2