Failure of Importing Large MySQL Database file

What if you are moving from one webhost to another webhost or from the old webhosting account to a new one or from one domain to the other. You already have uploaded all your websites files into the server but you failed to import your website’s data into your database.

Your MySQL Database file is too large for your PHPMyAdmin script to handle. And everytime you import the MySQL file, it is always affected by the browsers’ time limit of waiting for the response of the PHPMyAdmin which resulted to import failure. But this is not always the case. Sometimes, the timeout is caused by the failure to connect into the internet or by the dowtime of the server. And most often, PHPMyAdmin was set to a lower limit in processing SQL commands.

So, what should you do?

Actually, I don’t have problems of importing large MySQL data from a database backup file since the host of this blog configured the MyPHPAdmin script in a way that it will continue  importing a database file  even if the importing process is interrupted by some limitations.

Just recently, the PHPMyAdmin script installed with my hosting account successfully imported a 36,000KB MySQL backup database file of this blog in two attempts. First, the PHPMyAdmin executed few thousands of SQL commands and when it reached the limit of the number of SQL command execution, it stopped importing but told me to upload same file again so that it would continue importing the database file starting where he previously stopped, and that what was happened.

But not all PHPMyAdmin script used by us could handle large MySQL files. I am just lucky that the PHPMyAdmin script installed on my host’s server is capable of handling large database file.

BigDump Script

However, you have nothing to worry of if you couldn’t import a MySQL data using the PHPMyAdmin. There’re other ways besides using the PHPMyAdmin. The easiest way of importing large data is by the use of the BigDump script.

Staggered import of large and very large MySQL Dumps (like phpMyAdmin 2.x Dumps) even through the web-servers with hard runtime limit and those in safe mode. The script executes only a small part of the huge dump and restarts itself. The next session starts where the last was stopped.

The function of the BigDump script is to divide the large MySQL file into several smaller files. It will start importing the data on the first smaller file into your database. After reaching the end portion of that file, the BigDump will automatically refresh itself and import the data on the next smaller file…and so on… until the whole database is successfully imported into your Blog’s Database.

What you need to do is to download the BigDump Script. Open it with a Wordpad or any text processor and configure the following:

• Database Server
• Database Name
• Database Username
• How long to delay each session

Then save the file and close it.

Upload the edited or configured BigDumb script into your server using the FTP. Just place it in a folder, ie “data”, along with the MySQL backup database file you have in your harddisk. Make sure the folder is set to 777 permission setting.

To start the importing process, just point your browser to “yourblogsite.com/folder/bigdump.php” and just wait until the script finishes importing.

• Sign up for PayPal and start accepting credit card payments instantly.
  As the world's number one online payment service, PayPal is the fastest way to open your doors to over 150 million member accounts worldwide.
• Promote your product to high quality, targeted websites and blogs.
  Find effective, influential blogs and highly targeted audiences to advertise.Choose to display your ad across entire blog networks to maximize your exposure to a wide audience.