MySQLBackup is a script that allows you to make date-time stamped backups of individual MySQL databases. Each database backup is a gzip compressed SQL script that can be restored and imported via the mysql command line tool. The tables of each database being backed up are locked, preserving data integrity. While this does temporarily prevent writes to the tables, the impact is reduced by backing up each database separately. This script backs up all databases accessible to the mysql user that it is configured to use. That means this script is useful to the sysadmin as well as to regular users who wish to maintain backups of their own MySQL databases.
