FREE SOFTWARE DIRECTORY

MySQL Backup

MySQL Backup is a Perl script that uses mysqlshow to grab the database names and "show tables" to grab the table names for a user's account, and then uses mysqldump to save the data in a subdirectory named in the script. It then tars and gzips the files, using the date and time for the file name.

It can be run from cron on a daily basis. It removes old files and has an option to email the gzip file to an admin and/or FTP the backup file to a remote server. It also has options to use "select data into outfile" or a regular "select" for users who can't use mysqldump. It supports LARGE sets of databases and tables (GNU/Linux utilities such as tar, ls and nice break when the argument list gets too long). To do this, the script places all the sql text files in a subdirectory and tars the directory. For security, if a .my.cnf file is used then mysqlshow and mysqldump run without the --user and --password parameters, so the password doesn't display in the process list.

Last updated 11 Jun, 2002