Browse wiki
This entry published by the Free Software Foundation.
| MySQL Backup |
| Computer languages | Perl + |
|---|---|
| Database | sql + |
| Documentation note | Paid technical support,consulting, and programming available from http://worldcommunity.com/programming.html |
| Full description | MySQL Backup is a Perl script that uses my … 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. sword doesn't display in the process list. |
| Homepage URL | http://worldcommunity.com/opensource/utilities/mysql_backup.html + |
| Interface | command-line + |
| Is GNU | false + |
| Keywords | backup + , database + , mysql + , tar + , gzip + , MySQL Backup + |
| Last review by | Janet Casey + |
| Last review date | 11 June 2002 + |
| License | GPLv2orlater + |
| License verified by | Janet Casey + |
| License verified date | 25 May 2001 + |
| Name | MySQL Backup + |
| Prerequisite description | MySQL + |
| Prerequisite kind | Required to use + |
| Real name | Peter F. Brown + |
| Resource URL | mailto:peterbrown@worldcommunity.com + |
| Resource audience | Bug Tracking + , Developer + , Support + |
| Resource kind | E-mail + |
| Revisionid | 5,491 + |
| Revisiontimestamp | 12 April 2011 14:44:14 + |
| Revisionuser | WikiSysop + |
| Role | Maintainer + |
| Short description | Backs up databases + |
| Submitted by | Database conversion + |
| Submitted date | 1 April 2011 + |
| User level | none + |
| Version comment | 2.7 stable released 2002-06-11 |
| Version date | 11 June 2002 + |
| Version download | http://worldcommunity.com/opensource/utilities/mysql_backup.txt + |
| Version identifier | 2.7 + |
| Version status | stable + |
| Works-with | database + , sql + |
| Modification dateThis property is a special property in this wiki. | 25 May 2012 01:42:44 + |
| Page has default formThis property is a special property in this wiki. | Entry + |
| EmailThis property is a special property in this wiki. | peterbrown@worldcommunity.com + |
| hide properties that link here |
| MySQL Backup#3 + | License of |
|---|---|
| MySQL Backup#1 + | Person of |
| MySQL Backup#2 + | Resource of |
| MySQL Backup#4 + | Software prerequisite of |
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. A copy of the license is included in the page “GNU Free Documentation License”.
The copyright and license notices on this page only apply to the text on this page. Any software described in this text has its own copyright notice and license, which can usually be found in the distribution itself.