1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

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

Discussion in 'Plesk for Linux - 8.x and Older' started by arvin, Jun 26, 2006.

  1. arvin

    arvin Guest

    0
     
    hello every body!

    when I use

    Code:
    mysqldump -uadmin -ppasswd -A > /mnt/backup
    what user/pass must be use?!

    thnx in advance!
    rvn
     
  2. breun

    breun Golden Pleskian

    29
     
    Joined:
    Jun 28, 2005
    Messages:
    1,647
    Likes Received:
    0
    Same password you use to login to the Plesk web interface.
     
  3. arvin

    arvin Guest

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

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

    breun Golden Pleskian

    29
     
    Joined:
    Jun 28, 2005
    Messages:
    1,647
    Likes Received:
    0
    Can you get into mysql using this?

    Code:
    mysql -uadmin -p`cat /etc/psa/.psa.shadow`
     
  5. arvin

    arvin Guest

    0
     
    Yes, I can.
     
  6. breun

    breun Golden Pleskian

    29
     
    Joined:
    Jun 28, 2005
    Messages:
    1,647
    Likes Received:
    0
    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):

    Code:
    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).
     
  7. arvin

    arvin Guest

    0
     
    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!
     
  8. prupert

    prupert Guest

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

    arvin Guest

    0
     
    Yes, this is workoing for me!
     
Loading...