Rather than use –all-databases, which will prevent you from being able to selectively restore any single database, consider the following: Ideally, you should have a daily backup, with some history. It should be bulletproof (–force), it should be logged (>> …log), it should be compressed (| gzip), it should keep separate copies of each database, [...]
Archive for December 26th, 2009
Example Automated MySQL Backup Script
Posted in Linux, System Administration, Technique, tagged backup, Backup Script, MySQL, System Administration on December 26, 2009 | Leave a Comment »