Red Squirrel
[H]F Junkie
- Joined
- Nov 29, 2009
- Messages
- 9,211
I use mysqldump to dump the entire databases to a single file then tar it. For some servers I also have scripts that backup specific DBs to their own file to make it easier to restore. Basically these are just bash scripts that run in cron.
I'm just curious to know what others do. I would like to be able to do a backup job that backups all databases but puts them in their own file, without me having to go in and update the script if I add new DBs. Is there an easy way of doing this?
I was just about to restore a backup to a server when it occurred to me I would probably break lot of stuff because there is the mysql schema and other system DBs as part of that backup. This was not a disaster recovery situation so not a huge deal, just going in phpmyadmin to grab the DBs manually from the old server, but it got me thinking I definitely need a better approach.
I'm just curious to know what others do. I would like to be able to do a backup job that backups all databases but puts them in their own file, without me having to go in and update the script if I add new DBs. Is there an easy way of doing this?
I was just about to restore a backup to a server when it occurred to me I would probably break lot of stuff because there is the mysql schema and other system DBs as part of that backup. This was not a disaster recovery situation so not a huge deal, just going in phpmyadmin to grab the DBs manually from the old server, but it got me thinking I definitely need a better approach.