Add to Favourites Add to Favourites    Print this Article Print this Article

We have recently moved a customer to the Plesk server. I have dumped the contents of his MySQL database. How can we make the database accessible to the client from their Plesk CP.

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

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 use:

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

Was this answer helpful?

Also Read