3 ways to import and export a MySQL database

Nobody ever really wants to move a database, but it is a frequent necessity. Here are the most common options and when to use each one

Become An Insider

Sign up now and get FREE access to hundreds of Insider articles, guides, reviews, interviews, blogs, and other premium content. Learn more.

Nobody ever really wants to move a database, but it is a frequent necessity. Servers get old, providers become unreliable, disk space runs out. In the case of MySQL database migration, you have many options for accomplishing the task. I’ll discuss three of the most common options and when to use each.

Option 1: phpMyAdmin

Whether you’re renting servers or running your own, chances are you have phpMyAdmin installed to manage your MySQL installations. This PHP staple has been the most common MySQL management tool for over a decade.

phpmyadmin.jpg

Migrating a database is as simple as selecting the database in the left column, clicking the Export link, and saving the database to a file. Then on the new server, select the database in the left column, click the Import link, and choose the file you just exported. Easy.

Use this method when:

To continue reading this article register now