Home / Tutorials / Import SQL dump using BigDump

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:
// Database configuration

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

  • 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.
// How many lines may be considered to be one query (except text lines)</span>

$max_query_lines = 50000;
  • 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

Maintaining the blog for the past 3 years, I’m a Foodie, Techie, Cricket Enthu, Traveler, Blogger and a Cook ! You’ll find posts within a wide range of topics from food to technology.

Favorite Quote: “Traveling is like reading a book, one who hasn’t traveled, hasn’t turned a page.

Check Also

Freedom251 website goes down.

Impact of Flash Sales in India: Crashed Servers

E-commerce websites now days are tying up with device manufacturers to sell the devices from …

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

Get Amazing Stories

Get a weekly digest of all the posts from the blog delivered right to your inbox, just a click away, Sign Up Now - We promise, we'll never spam.
Name
Email address
Secure and Spam free...
%d bloggers like this: