Backup your MySQL databases automatically with AutoMySQLBackup
Submitted by srlinuxx on Sunday 28th of May 2006 02:44:23 AM
Filed under
If you site relies on MySQL and stores its sensitive data in a MySQL database, you will most definitely want to backup that information so that it can be restored in case of any disaster (manual mistake to delete some data, software errors, hardware errors, server compromise, etc.). In a previous post I have presented that MySQL provides the basic tool (mysqldump) to perform database backups. This is required because backing up a database is a little different than backing up regular files.
With mysqldump anyone can write a small shell script and running it from cron, it will achieve an automatic backup solution. There are many such scripts already available freely and also many commercial solutions also (I assume as I have not tested any really 
). The script that I liked the most is AutoMySQLBackup, because it doesn’t have any real requirements (mysqldump of course is needed - in any mysql client package - and gzip or bzip2 to compress the resulting file) and has all the features I was looking for in such a script.
»
-
- Login or register to post comments
Printer-friendly version- 75535 reads
PDF version
More in Tux Machines
- Highlights
- Front Page
- Latest Headlines
- Archive
- Recent comments
- All-Time Popular Stories
- Hot Topics
- New Members
| KDE Apps Mid-Year Update (KDE.news) | 38 weeks 3 days ago |
| OMG! Ubuntu! | 38 weeks 3 days ago |
| In Slashdot today | 38 weeks 3 days ago |
| KaOS 2022.06 Release Adds KDE Plasma 5.25 | 38 weeks 3 days ago |
| Another Linux Weekly Roundup | 38 weeks 3 days ago |
more
.svg_.png)
Content (where original) is available under CC-BY-SA, copyrighted by original author/s.
