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

3 ways to import and export a MySQL database
Thinkstock

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.

To continue reading this article register now