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
To dump database use:
# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` "database name" > "database name".sql