How to back up/restore Plesk system databases

• 

  Alex Rubio Cazador August 11, 2018 09:15

  I have a issue when i try to do this command included in a crontab

  plesk db dump DATABASE_NAME > C:\FULL\PATH\TO\FILE_NAME.sql

  when I execute manually the command runs perfect and i can backup all my sql files, but when i use this comend inside a crontab, they create and retund the .sql files empty

  Thank you.

  0

  Permalink
• 

  Denis Bykov August 19, 2018 19:59

  @Alex Rubio Cazador
  Try using the full path to the executable instead of the alias:

  For Linux:

  # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin DATABASE_NAME > /full/path/to/BACKUP_FILE_NAME.sql

  For Windows Server:

  C:\>"%plesk_dir%\Mysql\bin\mysqldump.exe" -uadmin -p<plesk_admin_password> -P8306 DATABASE_NAME > C:\FULL\PATH\TO\FILE_NAME.sql

  0

  Permalink
• 

  santhosh September 06, 2018 05:35

  hai am new to plesk am getting error while am updating plesk

  Internal error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.ServiceInstallations' doesn't exist

  how to rectify this error

  0

  Permalink
• 

  Ivan Postnikov September 07, 2018 18:30

  Hello @santhosh,

  This behavior may be caused by several issues:
  
  

  • Server is running out of RAM.
  • Some limits are exceeded on a container or on a hardware node.

  1. Connect to the server via SSH;
  2. Make sure that it is enough memory or container resources:

     # free -m
     # cat /proc/user_beancounters

     There should be enough memory and all 'failcnt' values should be 0. 

     Do the following in order to fix the issue:

     1. If you are leasing a virtual container, please contact your service provider in order to increase container limits.
     2. Increase amount of RAM or SWAP on the server.
  3. After fixing the limits issue, re-run the upgrade How to upgrade Plesk to the next release

  Check this article for reference:
  https://support.plesk.com/hc/en-us/articles/360006408573-Unable-to-open-Plesk-after-upgrade-Table-psa-ServiceInstallations-doesn-t-exist

  0

  Permalink
• 

  iamkingsleyf June 10, 2019 11:51

  Can i use this to restore a domain that was deleted?

  0

  Permalink
• 

  Alexey Lapshin June 11, 2019 02:46

  Hello @iamkingsleyf,

  For restoring whole domain (subscription) it is required to use the backup, created by backup manager.
  Navigate Tools & Settings > Backup Manager > select required backup and choose the subscription you need to restore.

  Use the following articles as reference:
  https://support.plesk.com/hc/en-us/articles/115000340534-How-to-create-and-restore-the-backup-for-certain-subscription-domain-
  https://docs.plesk.com/en-US/12.5/administrator-guide/advanced-backing-up-and-recovering-websites/restoring-backups.65200/

   

  0

  Permalink
• 

  Sergio Sanchez June 13, 2019 09:40 (Edited June 13, 2019 09:42)

  Please note that ...
  plesk db dump <database_name> > /path/to/<dump_name>.sql
  ... and the respective ...
  MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -uadmin <database_name> > /path/to/<dump_name>.sql
  .. as well as the backups generated in the backup manager (I assume the same tools are used) will not backup created events.

  To include events use
  MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -uadmin <database_name> --events > /path/to/<dump_name>.sql

  Would be nice to see this added to the the backup manager as I was quite astonished to see that my database backups do not contain events.

  0

  Permalink
• 

  George Alibegashvili June 13, 2019 13:08

  Hello @Sergio Sanchez,

  Thank you for your suggestion.

  I've created User voice request for this feature
  https://plesk.uservoice.com/forums/184549-feature-suggestions/suggestions/37900933-include-mysql-events-in-plesk-backups
  Please vote for this suggestion and feel free to discuss it there, the top-ranked suggestions are likely to be included in the next versions of Plesk.

  0

  Permalink

Please sign in to leave a comment.