System backup & databases

sp3ctre69

• August 15, 2017 13:45

This is probably an easy one for someone to answer, but probably worth asking anyway. I am backing up all my sites, along with the system backup, and shipping them off-site... I was wondering why one of my servers has a 24G system backup, so I investigated what the system backup backs up... the bulk of it (in my case) is the MySQL directory, with all the databases. My question is, when each site backup contains the databases that match the site, why also backup the database in the system backup? I'm sure there is a logical explanation for it!

• 

  Ekushey

  • August 15, 2017 19:03

  When you select "Per Account and Entire MySQL Directory" from Backup SQL Databases settings, it backs up copies of all the databases from your cPanel accounts, as well as all of the databases on the server (/var/lib/mysql/ directory). If you want to backup databases from cPanel accounts only, then select the "Per Account Only" option.

  0
• 

  cPanelMichael

  • August 15, 2017 19:33

  Hello @sp3ctre69, The previous post is correct. The "/var/lib/mysql/" directory is included with > Backup Configuration". Thank you.

  0
• 

  sp3ctre69

  • August 15, 2017 20:12

  ok, that makes sense... why would you want them backed up separately though? If you want to restore a site you need to restore the site backup, which contains the DB. If you don't want to restore the site then why would you want the database?

  0
• 

  Ekushey

  • August 15, 2017 20:21

  Well, I may want the database dumps separately, helpful when I'm doing a server migration. For most people "Per Account Only" option is just fine, which saves a lot of space too.

  0

Please sign in to leave a comment.