Article ID: 932, created on Oct 6, 2008, last review on May 2, 2014

  • Applies to:
  • Plesk 10.x for Linux
  • Plesk 9.x for Linux/Unix
  • Plesk 8.x for Linux/Unix


Login to Parallels Plesk Panel and create an empty database with name similar to client's database (<database name>):

Domains -> "domain name" -> Databases -> Add New Database

Configure database user:

Domains -> "domain name" -> Databases -> "database name" -> Add New Database User
This will create all required links to make the database open through the control panel.

Then upload the database SQL file using phpMyAdmin:

Domains -> "domain name" -> Databases -> "database name" -> Webadmin: Import

Another way to import the data from SQL file to MySQL via command line is as follows:

~# mysql -uadmin -p`cat /etc/psa/.psa.shadow` -D  "database name" < "database name".sql

Additional information

To dump database <database name> use:

# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` "database name" > "database name".sql

a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 b8ef5052d936e902043e41759118114e 6ef0db7f1685482449634a455d77d3f4 dd0611b6086474193d9bf78e2b293040 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF