WebHostRight

From time to time to may find yourself needing to upload a database to your web host account, maybe you have switched from one company to another and are running scripts that work with MySQL and PHP and so you find yourself having to put the database in place on a new hosting account.

Well you can actually do it through phpmyadmin and for some people they are successful using this method to upload databases, but for other customers it can be a different matter and you will often find that while trying to upload a database through phpmyadmin that it will timeout.

Basically what this is, is that the web host will have a time limit set and while trying to import your database it will only partially upload it before running out of time.

I experienced this myself and tried a few attempts to get the database to complete uploading to the web host, after a number of attempts i began searching for other options and to see if there was a way around this.

Well the good news is there is a handy solution and its completely free and goes by the name of Bigdump and basically how it works is by using staggered import, so that the upload is done in sections and can carry on where it left off.

It is ideal for importing large databases that would seem impossible to get imported through phpmyadmin, my databases that i needed to import where actually quite small, and i thought that importing them through phpmyadmin would be no trouble, but i soon found out that it was not working for me, so i was happy when i found bigdump and the import time for each database was only about one second.

There are instructions at the website and the process is really quite easy, you need to be able to use ftp to be able to upload a small php file, there are a few cases where it may not work for all situations but generally it can be the solution for many people who are having trouble trying to import a database at their hosting account.

I hope that this will make importing of your databases easier at your web hosting and will be glad to hear if it helped you or if you experienced any problems with it.