Language Selection

English French German Italian Portuguese Spanish

Backup your MySQL databases automatically with AutoMySQLBackup

Filed under
HowTos

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 Wink ). 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.

Full Story.

More in Tux Machines

Type Title Author Replies Last Postsort icon
Page Tux Machines IRC Logs 2021 Archive Roy Schestowitz 26/12/2022 - 4:29am
Story Nate Graham: KDE 2021 roadmap mid-year update Roy Schestowitz 1 27/06/2022 - 5:08pm
Story digiKam 7.7.0 is released Roy Schestowitz 27/06/2022 - 5:02pm
Story Mozilla Firefox 102 Is Now Available for Download, Adds Geoclue Support on Linux Marius Nestor 1 27/06/2022 - 5:00pm
Story Dilution and Misuse of the "Linux" Brand Roy Schestowitz 27/06/2022 - 3:14pm
Story Samsung, Red Hat to Work on Linux Drivers for Future Tech Roy Schestowitz 27/06/2022 - 3:12pm
Story How the Eyüpsultan district of Turkey uses GNU/Linux Roy Schestowitz 1 27/06/2022 - 3:02pm
Story today's howtos Roy Schestowitz 27/06/2022 - 3:00pm
Story Red Hat Hires a Blind Software Engineer to Improve Accessibility on Linux Desktop Roy Schestowitz 27/06/2022 - 2:49pm
Story Today in Techrights Roy Schestowitz 27/06/2022 - 2:48pm