Plesk: How to import a MySQL DB

This article provides you with steps to import a MySQL via Plesk.

Step 1– Login to Plesk.

  • Login with username and password received when you completed your application.

 

Step 2– Click on Databases

 

 

Step 3– Click on Add Database

 

 

Step 4– Complete Database details and click Save

 

 

Step 5 – Click on Import Dump and select your Database

 

 

Step 8: Since we add a prefix to the MySQL DB name the import will fail with below error: 

 

Solution

 

·        Open your MySQL database in a text editor and comment out the “CREATE DATABASE” line and change this line “USE `sysost`;” to “USE `ATM334_sysost`;” 

 

Was this post helpful?