How To Import a Large WordPress Database into PhpMyAdmin

Written by Jean Galea
Written by Jean Galea
A problem I frequently encounter when working with databases (especially large ones), is that they will cause problems when importing through PhpMyAdmin.

Partner Sponsors

BionicWP

Full disclosure: If you purchase through a link on our site, we may earn a commission. Learn more.

A problem I frequently encounter when working with databases (especially large ones), is that they will cause problems when importing through PhpMyAdmin.

An easy solution I’ve found is to use the BigDump script, as shown in the video below. Just thought I’d share with you guys in the hope that it will also be useful to those of you who encounter this issue with PhpMyAdmin.

If you enjoyed this post, make sure to subscribe to WP Mayor’s RSS feed.

This article was filed in our archives.
Written by Jean Galea
Jean Galea is an investor, entrepreneur, and blogger. He is the founder of WP Mayor, the plugins WP RSS Aggregator and Spotlight, as well as the Mastermind.fm podcast. His personal blog can be found at jeangalea.com.

In this article

Discover More

3 Responses

  1. Thanks for the screencast. I never faced any issues with PhpMyAdmin and incase if I notice any, I will use ” BigDump script” as per your instructions.

Share Your Thoughts

Your email address will not be published. Required fields are marked *

New discoveries, every week.
Join thousands of designers, developers, and builders that come to WP Mayor to find the best guides, tools, and services for their next website. One email, once a week.
WP Mayor Newsletter

Claim Your Free Website Tip 👇

Leave your name, email and website URL below to receive one actionable improvement tip tailored just for your website within the next 24 hours.

"They identified areas for improvement that we had not previously considered." - Elliot

By providing your information, you'll also be subscribing to our weekly newsletter packed with exclusive content and insights. You can unsubscribe at any time with just one click.

What's missing?