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`;”