Restoring a Single Database via phpMyAdmin
This article will explain how you can restore a single database via phpMyAdmin.
Note: when you import files using phpMyAdmin, the file size can not excess 2048KiB. If you need to transfer larger files, please refer to Backing up and Restoring a Single Database via SSH
Import a MySQL database via phpMyAdmin
Click “Launch” on the phpMyAdmin page in the Control Panel.
Log in to the phpMyAdmin interface with one of database user’s username and password.
1> From the database drop-down on the left, select the database you would like restore data to.
2>Click “Import” in the navigation bar at the top.
Choose the backup file from your local disk and click the Go button. The process runs.