In this tutorial we will show you how to manually IMPORT data from a MySQL database using PHPMyAdmin from cPanel and Plesk.

cPanel

  • DATABASE section —> select [phpMyAdmin]
  • To restore a database from phpMyAdmin, first, choose the database where you will import the data. This can be done from the menu on the left.
  • A new page will load showing the structure of the selected database. To import data into the database, click Import.
  • On the new page that opens, click on Choose file and select the backup you want to import from your computer. You have the option to choose the character set from the drop-down menu just below the upload box. If you are not sure which character set the database is using, leave the default. Once ready, click on Go to start the import.
  • The import will begin, and once finished you will be redirected to a page with a notification confirming that the import has been successfully completed.

Plesk

  • DATABASE section in the left menu —> select [phpMyAdmin] on the central page
  • To restore a database from phpMyAdmin, first, choose the database where you will import the data. This can be done from the menu on the left.
  • A new page will load showing the structure of the selected database. To import data into the database, click Import.
  • On the new page that opens, click on Choose file (select the file) and select the backup you want to import from your computer. You have the option to choose the character set from the drop-down menu just below the upload box. If you are not sure which character set the database is using, leave the default. Once ready, click on Go to start the import.
  • The import will begin and once finished you will be redirected to a page with a notification confirming that the import has been completed successfully.
Open chat