There are many reasons why you would want to import your MySQL database from the server. For instance, database migration is necessary as your account runs out of disk space and your server becomes obsolete. The same process is required if you need to take your business elsewhere as your current hosting provider increasingly becomes unpredictable and undependable. All in all, importing your MySQL files can ensure that your sites or databases are running smoothly.
The most efficient way of migrating your database is to use the MySQL command line to process your database import or export. But it’s the most difficult method. There are two easier ways to move your MySQL databases. Here they are:
Method 1. phpMyAdmin via cPanel
phpMyAdmin is a PHP-based software tool designed to handle MySQL over the web. If you have a hosting provider or you have your own server, then you must already have it installed in your system. To use phpMyAdmin when migrating your databases, simply access the Databases section on cPanel. Here are the steps involved:
This method is not without limitations. For one, you need to have phpMyAdmin installed on both the old and new servers for this method to work. The size of the database you can migrate must be below 50MB. Plus, you must ensure that the export file size also fits within the upload limits. Use this method if you have relatively small databases, such as that of a WordPress site. Otherwise, you may risk having partial or broken migration of files if you move huge databases.
Method 2. MySQL Workbench
If you don’t have phpMyAdmin or the size of the database that you’re moving is large, you can use this graphical user interface (GUI) tool that comes direct from MySQL. More than database migration, MySQL Workbench can also monitor the health of your servers and it comes with SQL data modeling. Here are the steps: