Announcement

Collapse
No announcement yet.

How to take Database backup on Linux Plesk Server?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to take Database backup on Linux Plesk Server?

    Hello,
    I have a Linux Plesk server and want to take the backup of MySQL database in Plesk.
    Can anyone help me in this regard?

  • #2
    Hi,

    You need to find databases at /var/lib/mysql directory on Linux Plesk server to take the backup of database.
    For Example:
    mysqldump -u admin database_name > database_name.sql -p
    enter password (you will get password in cat /etc/psa/.psa.shadow)
    To restore database backup file use the following command:

    mysql -u admin database_name < database_name.sql p
    after this you need to enter password. (you will get password in cat /etc/psa/.psa.shadow)

    Comment

    Working...
    X