My SQL Database

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:

On the old server, select and click on the left panel the database that you want to export. Next, click on Export tab on the upper part of the screen. Save the database to a file.

On the new server, select and click on the left panel the database that you want to import. Next, click the Import tab. Choose the file that you have just saved in Steps 1 to 3. When the process is completed, you’re migration is done.

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.

You can find out SQL database file in database folder name in our items zip file. after that you can import database in MYSQL panel.