Product:
Search Type:

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.

Article ID: 932 
Last Review: Apr,20 2006
APPLIES TO:
  • Plesk for Linux/Unix

RESOLUTION


You should create an empty database through the Plesk interface at "Domains
-> DOMAIN.TLD -> Databases -> Add New Database" and upload
the database SQL file using PHPMyAdmin. 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 < FILE.sql


To dump a database use:
# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` DATABASE > FILE.sql

Please provide feedback on this article

Did this article help you solve your issue?
Yes
No
Partially
I do not know yet
 
Strongly Agree   Strongly Disagree
  9 8 7 6 5 4 3 2 1
The article is easy to understand
The article is accurate
Additional Comments:
*Please provide us with your email address in case we need to contact you.
*Please type the code you can see.
* - required fields