Backup databases multiple times a day

furquan

• April 09, 2017 00:23

Hello everyone, I need to backup my all the databases of one account on daily basis on my server 4 times a day ( 12pm / 3pm / 6pm / 12am ) Can anybody on this forum please assist me in doing so using cPanel backup feature, Or do i have to use any third party software to accomplish this, as i will also need to use restore from time to time :( Thank you

• 

  SysSachin

  • April 09, 2017 07:37

  Hello, You can not setup such backup configuration with the cPanel backup feature. if you have root access of your server then you can setup the cron on for databases backup of your one of the account. Do you have root access of your server and how many databases you have created under that account ?

  0
• 

  furquan

  • April 09, 2017 07:39

  Hi Sachin, Yes i do have root access to the server, Can you please guide me for doing so ? Thank you

  0
• 

  furquan

  • April 09, 2017 07:57

  Sachin, My apologies for the overlook, It has over 200 databases in that account :( Thank you,

  0
• 

  cPanelMichael

  • April 10, 2017 18:12

  Hello, You'd have develop a custom bash script that generates a backup of the databases using a utility such as "mysqldump": MySQL :: MySQL 5.6 Reference Manual :: 4.5.4 mysqldump " A Database Backup Program Then, setup a cron job that runs the script multiple times per day. If you need help developing the custom bash script, you may find the following list of system admin services helpful: System Administration Services | cPanel Forums Thank you.

  0

Please sign in to leave a comment.