We do support Round the Clock 24 x 7 x 365 (+91) 883 012 3924
 

How to Backup and Restore Plesk system databases

How to Backup and Restore Plesk system databases

Plesk control panel interacts with the below different databases so we need to take backup of all those databases :

1. psa – Plesk system database
2. apsc – Plesk application database
3. mysql – MySQL system database
4. roundcubemail – Roundcube database
5. horde – Horde database
6. atmail – atmail database
7. sitebuilder5 – Web Presence Builder
8. phpmyadmin_* – phpMyAdmin database

Run below command to backup Plesk system databases :

  • For Plesk Onyx

    # plesk db dump <database_name> > /path/to/<dump_name>.sql
  • For Plesk 12.5 and previous releases

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -uadmin <database_name> > /path/to/<dump_name>.sql

Run below command to Restore Plesk system databases :

  • For Plesk Onyx

    # plesk db < /path/to/<dump_name>.sql
  • For Plesk 12.5 and previous releases

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin < /root/<dump_name>.sql

Please feel free to contact us at Support@L3webhosting.com if you require any assistance.

 

Leave a Reply

Your email address will not be published. Required fields are marked *