Backup databases multiple times a day

[furquan]

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]

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 ?

 

[furquan]

Hi Sachin,

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

Thank you

 

[furquan]

Sachin,

My apologies for the overlook, It has over 200 databases in that account

Thank you,

 

[cPanelMichael]

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.