Announcement

Collapse
No announcement yet.

Database backup on Linux Plesk Server

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

  • Database backup on Linux Plesk Server

    I have a Linux Plesk server and would like know how to take the backup of MySQL database backup in Plesk. Any help is appreciable.

  • #2
    To take the backup of database on Linux Plesk server you need to find databases at /var/lib/mysql directory. 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 below 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