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 [email protected] if you require any assistance.