”Don’t focus on having a great blog. Focus on
producing a blog that’s great for your readers.”- Brian Clark
 
 

Import Big MySQL Databases into phpMyAdmin with BigDump

30 March 2012

When we try to import large SQL files into MySQL via phpMyAdmin, we often receive the following error message: “You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.” It simply means that the MySQL Database file is just too big to import via phpMyAdmin web interface. By default phpMyAdmin stores the upload limit in the php.ini file. We can increase the upload limit size by editing the php.ini file if we have access to it, but if the database is on a shared web hosting, we won’t have access to modify this file.

One of the popular solutions is to install Big Dump (download here 12 KB zip). What it does is stagger the database import so the server does not timeout.

Instructions

  1. Open bigdump.php in a text editor and configure the database parameters (Server, database name, username, password, and the file name)
  2. Drop the old tables on the target database if your dump doesn’t contain “DROP TABLE” (via phpMyAdmin)
  3. Create a new folder called "dump" on the web hosting
  4. Upload the MySQL file and bigdump.php to the newly created "dump" folder via FTP
  5. Run bigdump.php from your browser (http://www.yourdomain.com/dump/bigdump.php) and import the MySQL file
  6. BigDump will start the import session automatically
  7. Wait a few moment (depends on how big the file size is) and we will see a confirmation screen
  8. Delete bigdump.php off your server

About Site by Tommy

Freelance web design and developer in Jakarta and Microsoft Certified Professional with five years of experience in web design and development, application development, database system, Search Engine Optimization (SEO), graphic design, logo design, business cards, corporate letterhead, posters/banners, brochures and flyers, social media marketing, and email marketing/campaign.

 
Project Highlight
 
What Client Says
 
I’ve Got You Covered
  • Website Design
  • Application Development
  • Database System
  • Search Engine Optimization
  • Web Hosting
  • Graphic Design
  • Logo Design
  • Business Cards
  • Corporate Letterhead
  • Posters/Banners
  • Brochures and Flyers
  • Event Invitations
  • Promotional Products
  • Social Media Marketing
  • E-mail Marketing/Campaign
  • Event Marketing