How to Import/Restore Your MYSQL Database Using phpMyAdmin
- Login to cPanel and select PHPMyAdmin
- Select the database which you wish to restore to the drop down database menu at the left. In this example, I'm selecting the database "joshipro_wptest1"
- The phpMyAdmin script that restores your database does not drop the tables first. Click the Check All / Check tables having overhead check box.
Click the With selected: drop down menu and choose Drop.
- Confirm by clicking 'YES'
- Click the Import tab. Next, click the Choose File button to browse for the MySQL backup. Lastly, press the "Go" button to complete the import process.
Updated on: 15/08/2018
Thank you!