Top > Database > SQL-type > MySQL Backup

MySQL Backup - Backs up databases

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 (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.



Obtaining

Web pagehttp://worldcommunity.com/opensource/utilities/mysql_backup.html
Source tarball http://worldcommunity.com/opensource/utilities/mysql_backup.txt
Version 2.7 (stable) released on 2002-06-11
Licensed under The GNU General Public License, Version 2 or later.
This is not a GNU package.

Documentation
Paid technical support,consulting, and programming available from http://worldcommunity.com/programming.html
Support contacts

Help List<peterbrown@worldcommunity.com>
Developer List<peterbrown@worldcommunity.com>
Bug List<peterbrown@worldcommunity.com>

Project contacts

Maintainers
Developers

Related information

Interfacescommand line
Source languagesPerl
Use requirementsMySQL

Entry information

License verified byJanet Casey <jcasey@gnu.org> on 2001-05-25
Entry compiled byJanet Casey <jcasey@gnu.org>

Categories



The copyright licensing notice below applies to this text. The software described in this text has its own copyright notice and license, which can usually be found in the distribution itself.

Copyright © 2000, 2001, 2002, 2003 Free Software Foundation, Inc.

Permission is granted to copy, distribute, and/or modify this document under the terms of the GNU Free Documentation License, Version 1.1 or any later version published by the Free Software Foundation; with no Invariant Sections, with no Front-Cover Texts, and with no Back-Cover Texts. A copy of this license is included in the file COPYING.DOC.

Please report any problems in this page to bug-directory@gnu.org, or find out how you can help fix them.

The FSF provides this directory as a service to the free software community. Please consider donating to the FSF to help support this project.