SELaplana >> Internet >> How to Import Large MySQL Database File

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.

Automatically receive updates via email...
Enter your email address:

Tags: Backup, Database, MySQL, PHPMyAdmin, Script
Tweet This!

Pinay Scandal

Actually, this terms refer to the photos, videos or any stories that reveal shameful, sxeperience, and secrets of some individuals or celebrities.

How to Transfer your WordPress blog from Old Webhost to the New Webhost?

Transferring your blog from your old webhost to your new webhost is actually easy if you know what to do. But of course you need

How to Transfer Your Blog to Another Server without Downtime?

My previous article talks about the steps in transferring or moving your blog from one server to another. On this article, we'll still be talking

How to Move Blog from Folder to Subdomain?

Let's just forget first the Hayden Kho Sex Video Scandal on this post. Let's give way to a question raised by a feed subscriber who

WordPress Post Revisions

Post Revisions tracking system was introduced on the Wordpress version 2.6. With this, everytime you save your post or the Wordpress system automatically saved your

WordPress database error You have an error in your SQL syntax

While trying to correct the error that has been logged in the error_log file regarding suhosin.so which I blogged at my post, PHP Warning: Module

How To Move WordPress.Com blog to Your Own Server?

Visitor's Email: Hello Mr. Laplana, This has nothing to do with sales or promotions or anything like that.  I just noticed that you have wordpress and your

Related Post Plugin

Related Post v 2.0.1 plugin by WASABI is the first plugin I installed on my Wordpress script for this blog. The setup script of this plugin

WordPress database error Illegal mix of collations

After successfully corrected the error caused by the Wordpress plugin called Pagination which I blogged at my post, WordPress database error You have an error

Search and Replace SQL Statement in MyPHPAdmin

There were times that I need to replace something from the content of my blog. But searching for those things takes time especially if you're

How to Move a WordPress Blog to a New Domain?

Feed Subscriber's Email I noticed that you changed the domain of your Maasin City News blog from its old subdomain "www.maasinnews.com/" to its new domain "maasinnews.com". I

Wordpres Plugin Database New Face

The Wordpress Pugin Database or the wp-plugin.net is now on its version 2. Lot of improvements have been applied into the sites. We can read this

UserOnline Plugin Error

I recently upgraded the blog's Wordpress engine to Wordpress v2.1. I experienced a problem on Link Dialogue but then it was resolved after a day. Today,

Best Webhost For Your Best Blogs

Tons of Filipino bloggers today are starting to shift from free-hosted blogs to own-hosted blogs as they started to realize that having their own-hosted blog

How do you fix exe files that has already infected by a worm?

User's Question: How do you fix exe files that has already infected by a worm? I just downloaded a game file yesterday and waited for

What Webhost’s Server is Best For a Busy Blog?

I already wrote articles before about webhosts. Few of those articles are: Picking the right webhost for your blog Best webhost for your blog But I think those

www.sss.gov.ph static information

sss gov.ph SSS Online Inquiry