Create copies of the database only?

JulianProg2019

• May 07, 2019 10:40

I need to make at least two copies of the database for each account. I have searched in the Cpanel configuration and also in the WHM and I do not see an option that allows me to generate copies only for the database, I only see that the copies of the database are included in the complete copies that are generated for each account. The only way I have seen to make an independent copy for each account is to do it manually by exporting from the cpanel> mysql database, but obviously the idea is to do this automatically at least 2 times a day? Is there any way? I repeat, only to make copies of the database apart from the other files in the account.

• 

  cPanelLauren

  • May 08, 2019 16:36

  Hi @JulianProg2019 The automated backup system won't do just DB's by default you can use the pkgacct script to only backup databases - The pkgacct Script - Version 78 Documentation - cPanel Documentation you would need to create a loop to go through all users and add it as a cron if you wanted it done automatically. Thanks!

  0
• 

  JulianProg2019

  • May 08, 2019 18:20

  Hi @JulianProg2019 The automated backup system won't do just DB's by default you can use the pkgacct script to only backup databases -

  0
• 

  cPanelLauren

  • May 08, 2019 19:13

  If you wanted an automatic solution, yes. You could create a db only backup through cPanel>>Files>>Backup Wizard -> Backup -> Partial -> MySQL databases but this would be a manual process.

  0

Please sign in to leave a comment.