Each database can be restored via the MySQL command line tool by calling gzipped archive.
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 backups all tables 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 whish to maintain backups of their own MySQL databases.
The script requires that your mysql connection information be stored in a my.cnf or .my.cnf file in the home directory of the user used to run this script.
What's New in This Release: [ read full changelog ]
· Modified sql connect string to no longer specify an initial database. Checks to make sure there is a [mysqldump] section in the ~/.my.conf file.