Home » Blogs » drupalab's blog

How to import big MySQL database

Fri, 5 Dec, 2008

Posted by drupalab at 23:24

216 comments

 If you have some MySQL database files that bigger than 100MB, it is difficult to upload and import via phpmyadmin. Please use bigdump at http://www.ozerov.de/bigdump.zip it is the best tool to import big database files.

1. Adjust the database configuration in this file
2. Drop the old tables on the target database if your dump doesn't contain "DROP TABLE"
3. Create the working directory (e.g. dump) on your web-server
4. Upload bigdump.php and your dump files (.sql, .gz) via FTP to the working directory
5. Run the bigdump.php from your browser via URL like http://www.yourdomain.com/dump/bigdump.php
6. BigDump can start the next import session automatically if you enable the JavaScript
7. Wait for the script to finish, do not close the browser window
8. IMPORTANT: Remove bigdump.php and your dump files from the web-server
 

photo
Posted by joan123 on 12 Mar 2010 at about 14:59.

Re: How to import big MySQL database

It’s hard to find knowledgeable people on this topic, but you sound like you know what you’re talking about! Thanks

Kennaday,
SEO

photo
Posted by joan123 on 12 Mar 2010 at about 15:21.

Re: How to import big MySQL database

Great post! Thanks for the information

Jones,
banner printing

photo
Posted by joan123 on 12 Mar 2010 at about 14:59.

Re: How to import big MySQL database

Awesome tips. I’ll be passing this post on for sure

Joan,
website designer melbourne

photo
Posted by kevin00000000001 on 12 Mar 2010 at about 19:52.

Re: How to import big MySQL database

Insightful piece, thanks a lot!
internet marketing

photo
Posted by selam on 15 Mar 2010 at about 11:16.

Re: How to import big MySQL database

yabancılar çalışma izni yabancılar çalışma izni
yabancı personel çalıştırma yabancı personel çalıştırma
turizm belgesi turizm belgesi
iso belgesi iso belgesi
ikamet tezkeresi ikamet tezkeresi
teşvik kredisi teşvik kredisi

photo
Posted by anuj on 15 Mar 2010 at about 23:05.

seo

PSD to Joomla
blackberry application developer
Distribute iPhone Application
PSD to Drupal Template
android applications development
Convert Image to HTML Code
Cell Phone Product Development

photo
Posted by buildmusclefast1 on 16 Mar 2010 at about 12:26.

Re: How to import big MySQL database

I have MySQL database files that bigger than 100MB, it is always difficult for me to upload and import via phpmyadmin. So i found your article very helpful for me onwards now. Thank you very much.

how to build muscle fast

photo
Posted by iphonegames on 19 Mar 2010 at about 17:29.

Re: How to import big MySQL database

MySQL now getting rapid growth in development industry and the new challenges making it stronger. Thank you very much for your informative post.

iPhone Games

photo
Posted by pokercouponcode on 21 Mar 2010 at about 16:47.

Re: How to import big MySQL database

Upload bigdump.php and your dump files (.sql, .gz) via FTP to the working directory AND Other options help me alot to understand it more clearly. thanks buddy.

Titan Poker coupon code