Mysql Commands for Plesk Control Panel

[kaustubh_s]

Q. How do I take mysqldump backup of the database with "admin" user?

Ans :

mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` dbname > backupfile.sql

Q. How do I restore the mysqldump backup to the empty database with "admin" user?

Ans :

mysql -uadmin -p`cat /etc/psa/.psa.shadow` dbname < backupfile.sql

The command " cat /etc/psa/.psa.shadow " returns the password for admin user.

One can explicitely metion admin password in the command like below.

Assume that the admin user has password 123admin321, then commands will be.

mysqldump -uadmin -p123admin321 dbname > backupfile.sql

mysql -uadmin -p123admin321 dbname < backupfile.sql

: No space after -u or -p

[kaustubh_s]

Here are two more important commands

Mysql check to Repair

mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow` -r databasename

Mysql check to Optimize

mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow` -o databasename

[ivaak]

Hello,
Really amazing information and views you have put up here,
This will helpful for user’s of this forum.

[oliver]

Hello,
Really amazing information and views you have put up here,
This will helpful for user’s of this forum.

I hope you would try to contribute something similar rather than just complimenting others posts.