janus_zonstraal wrote: ↑
Sat Nov 09, 2019 9:20 am
You don't need MySQLDumper
Just run a script with Cron and ready, I backup all my databases every 4 hours
If you want a highly configurable script google automysqlbackup, note there is a lot more involved with it than just creating a cron job . Default is to create a backup every 24 hours. Basic settings allow for daily backups which are rotated out after 7 days, weekly backups rotated out every 4 weeks and monthly backups rotated out every 6 months but you can adjust as needed. In other words after it runs for six months you will have a backup for every day for the last 7 days, a backup for every week for four weeks and a backup for one month going back six months.
One thing to keep in mind about backups is you want to preserve previous backups within reason. If for example some unnamed nitwit reuses a forum with pruning enabled and moves a bunch of posts into it, then proceeds to overwrite the only backup with new backup after the posts have been pruned a few days later without realizing his mistake.... they are gone.
I have script for FTP to sync bakup folder on the server with local machine but there is lot of options for this. You can for example FTP it to backup server or email it. Also options for encrypting them. There is also options for incremental backups if you have large database and want to do it hourly or whatever.
It's worth exploring if you want a robust automated solution.
“Results! Why, man, I have gotten a lot of results! I have found several thousand things that won’t work.”
Attributed - Thomas Edison