Backing up database ( dashboard )
Permalink
Hi,
After going through many problems with my local back-ups of databases was wondering if there is a script ( cron ) that we can run to do daily back-up of mysql databases with our concrete sites. There is a back-up button in the dashboard. Is there an add-on or something that can automate this on a daily schedule?
Just curious
Jim
After going through many problems with my local back-ups of databases was wondering if there is a script ( cron ) that we can run to do daily back-up of mysql databases with our concrete sites. There is a back-up button in the dashboard. Is there an add-on or something that can automate this on a daily schedule?
Just curious
Jim
I found this whilst Google searching
http://www.classicwebdesign.com/db_backup/...
This would do pretty much what I was wanting - I'll give it a shot and post results back here
http://www.classicwebdesign.com/db_backup/...
This would do pretty much what I was wanting - I'll give it a shot and post results back here
What about this add-on by JohntheFish.
http://www.concrete5.org/marketplace/addons/backup-voodoo/...
Why are you spending countless hours 'rolling your own' when there is a comprehensive and inexpensive solution in the marketplace?
http://www.concrete5.org/marketplace/addons/backup-voodoo/...
Why are you spending countless hours 'rolling your own' when there is a comprehensive and inexpensive solution in the marketplace?
Countless hours ... surely you jest?
It takes minutes to set up.
It takes minutes to set up.
My point wasn't that your solution takes hours to implement. My point was that there are solutions already invented and perhaps purchasing something would take far less time than researching and experimenting with different solutions. Cron jobs are a pain to implement on some hosts so there's no guarantee that your solution will work without more time investment. Backup Voodoo is a great, inexpensive, flexible and comprehensive solution.
Backup Voodoo looks like a fine add-on but OP specifically asked about CRON ... innit!?
Backup Voodoo comes with a range of concrete5 jobs that can be used in various combinations to automate a range of backup requirements via cron.
The interrelated cron jobs used to be difficult to setup, but with Queueable Jobs now available on c5.6.2, setting up a sliced backup job using Voodoo is now straightforward.
The interrelated cron jobs used to be difficult to setup, but with Queueable Jobs now available on c5.6.2, setting up a sliced backup job using Voodoo is now straightforward.
If you're experiencing any problem with cron job, you can try free online cron job provider likehttp://www.easycron.com
I run something like this on a weekly basis (cron):
mysqldump -u <user> -p<your_password> --all-databases | gzip > /<your>/<path>/all_DBs_bak_`date +\%Y.\%m.\%d.\%H\%M`.sql.gz
http://www.concrete5.org/marketplace/addons/backup-job/...