Import SQL dump using BigDump

There might have been occasions where you had to move/copy one of your databases which are huge in size (few MBs and so on). Trying to import it normally i.e. using PHPMyAdmin isn’t a solution as it doesn’t allow you to export such huge dumps. Here’s where BigDump steps in.

BigDump is light weight utility which allows you to import big databases to your server. This teeny-weeny utility has been written in PHP and comes very handy to database professionals whose most work is in PHP.

Using this utility is very easy.

  • Download BigDump from here.
  • Extract the zip folder in your www directory.
  • Now open the bigdump.php script in your favorite editor and make the following changes:
[code language=”php”]

// Database configuration

$db_server = ‘<your dbhost>’;
$db_name = ‘<your dbname>’;
$db_username = ‘<your db username>’;
$db_password = ‘<your db password>’;

[/code]
  • After this search for  $max_query_lines and change it a large value, eg: 10000. This is required if you get any error while import your dump.
[code language=”php”]

// How many lines may be considered to be one query (except text lines)</span>

$max_query_lines = 50000;
[/code]

  • Once you have made these changes, copy your .sql dump file in the folder where you extracted BigDump.
  • Open your browser and point it to the folder where bigdump.php resides. Eg. localhost/mysite/bigdump/bigdump.php
  • You should see your dump.sql file in the list, choose that file and hit import.
  • Sit back and let this magical tool cast a spell !
Screenshot of the importing process. Courtesy: Atulmaharaj
Screenshot of the importing process. Courtesy: Atulmaharaj

This tool came very handy while I was trying to import a database. Thought to share with everyone as it might be useful to many. In case of any issues, do leave your comments below ! Cheers !

About Atulmaharaj

A seasoned blogger and a content marketer for close to a decade now. I write about Food, Technology, Lifestyle, Travel, and Finance related posts. Blogging brings me joy and the best part is I get to read and e-meet so many amazing bloggers! PS: I'm also the founder for Socialmaharaj.com :) Favorite Quote: "Traveling is like reading a book, one who hasn't traveled, hasn't turned a page.

Check Also

1 GB VPS server Performance Tips

4 Performance tips for 1 GB VPS – run high traffic websites

The notion that the more the RAM, the better the performance is quite common in …

2 comments

  1. Bro, there is a command mysqldump, i copy database more than a GB using it, you must give it a try !

Share your thoughts

This site uses Akismet to reduce spam. Learn how your comment data is processed.