I recently was in a situation when I had to push code for a new website to my server. Simple enough, except that I could not access the phpmyadmin by remote or local method. (Local method means accessing phpmyadmin installed on the hosting server itself, whereas remote method means using phpmyadmin on your own system ,for eg. i had it installed as part of wamp, to access the mysql database of remote server.)

There were large queries to be made and i didn't want to type it all on the console. It was at this time that i came across bigdump script . What it actually does , is that it excutes your mysql dump( usually generated by an export of your database). That is, it imports a database to the server.It is a very good script made specially for problems like this .

The steps involved are as follows,

  1. Create a folder(let its name be dump).
  2. Transfer the bigdump.php and the dumped sql file in that folder.
  3. On your browser, enter the path to the script.
  4. The script will ask your permission to run the queries in database.

The script itself is customizable. Few things to be kept it mind,
  1. You need to change database login credentials in the script.
  2. If the dump contains CREATE DATABASE  query, we need to uncomment a line in the script.

With these things in mind, bigdump turns out to be a very useful tool