mysqldump -uadmin -ppasswd -A > /mnt/backup what user/pass?!!

[arvin]

hello every body!

when I use

mysqldump -uadmin -ppasswd -A > /mnt/backup

what user/pass must be use?!

thnx in advance!
rvn

 

[breun]

Same password you use to login to the Plesk web interface.

 

[arvin]

thnx and I know that but when i try adminpass of plesk the access error accured:

 1045: Access denied for user: 'admin@server' (Using password: YES) when trying to connect

 

[breun]

Can you get into mysql using this?

mysql -uadmin -p`cat /etc/psa/.psa.shadow`

 

[arvin]

Yes, I can.

 

[breun]

Then I think you made a typo the first time around. To see your Plesk password type cat /etc/psa/.psa.shadow. This should work too (of course specifying a valid file name and path):

mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` -A > /path/to/file

I think you've probably mounted a drive at /mnt/backup so I'd not > directly to /mnt/backup, but rather use something like /mnt/backup/mysql-all.dump or /mnt/backup/mysql-all-`date +%Y%m%d-%H%M`.dump (if you want the date and time in the filename).

 

[arvin]

oh , very thnx to your complete answer,

YEAH, just Work!

that's right, i have a back up hard, and yes mybe i take a mistake in typing passwd!!!

you pattern for using % template taste very delicious!

thnx any way breun and i keep my finger cress for you!

 

[prupert]

Please let us know if it's working for you.

 

[arvin]

Yes, this is workoing for me!