With Panel, to export a database means to save a source database in a file which can be used for storage or distribution. To import a database means to restore data from the file to a destination database. You can import a database to the same or another database server. The only restriction is that the destination database should be of the same type, for example, MySQL.
One reason for exporting databases is to back them up. While Panel for Windows offers a separate functionality for backing up databases, on Panel for Linux, exporting is the only option for creating separate database backup files.
The export and import functionality is provided by the database management tool available through the Webadmin link in Websites & Domains > Databases.
How to export database via phpMyadmin
Please follow the following step:
1) Login to Plesk control panel.
2) Click on Websites & Domains > Click Databases.
3) Select the corresponding Database Name from the list. > Click Webadmin.
4) Click on Export.
5) Click Go.
How to import database via phpMyadmin
Please follow the following step:
1) Login to Plesk control panel.
2) Click on Websites & Domains > Click Databases.
3) Select the corresponding Database Name from the list. > Click Webadmin.
4) Click on Import.
5) Browse your computer to locate .sql file.
6) Click Go.
Import has been successfully finished.(localhost.sql)
