Difference between revisions of "MySQL Backup"
(Created page with "{{Entry |Name=MySQL Backup |Short description=Backs up databases |Full description=MySQL Backup is a Perl script that uses mysqlshow to grab the database names and "show tab...") |
(testing url underscores) |
||
| (6 intermediate revisions by one other user not shown) | |||
| Line 3: | Line 3: | ||
|Short description=Backs up databases | |Short description=Backs up databases | ||
|Full description=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. | |Full description=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. | ||
| + | |Homepage URL=http://worldcommunitypress.com/services/free-opensource-software/ | ||
|User level=none | |User level=none | ||
| − | |||
| − | |||
| − | |||
| − | |||
|Computer languages=Perl | |Computer languages=Perl | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|Keywords=backup,database,mysql,tar,gzip,MySQL Backup | |Keywords=backup,database,mysql,tar,gzip,MySQL Backup | ||
| − | | | + | |Version identifier=3.7 |
| − | |Last review by= | + | |Version date=2015/03/12 |
| − | |Last review date= | + | |Version status=stable |
| − | + | |Version download=http://worldcommunitypress.com/opensource-files/mysql%5Fbackup%5Fscript%5F3%5F7.zip | |
| + | |Last review by=Dan Munro | ||
| + | |Last review date=2017/12/04 | ||
|Submitted date=2011-04-01 | |Submitted date=2011-04-01 | ||
| − | | | + | |Is GNU=No |
| − | |||
| − | |||
| − | |||
|License verified date=2001-05-25 | |License verified date=2001-05-25 | ||
| − | | | + | }} |
| + | {{Project license | ||
| + | |License=GPLv2orlater | ||
| + | |License verified by=Dan Munro | ||
| + | |License verified date=2017/11/16 | ||
}} | }} | ||
{{Person | {{Person | ||
| + | |Real name=Peter F. Brown | ||
|Role=Maintainer | |Role=Maintainer | ||
| − | |||
|Email=peterbrown@worldcommunity.com | |Email=peterbrown@worldcommunity.com | ||
| − | |||
}} | }} | ||
{{Resource | {{Resource | ||
| Line 42: | Line 35: | ||
|Database=sql | |Database=sql | ||
|Interface=command-line | |Interface=command-line | ||
| − | |Works-with=database,sql | + | |Works-with=database, sql |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
}} | }} | ||
{{Software prerequisite | {{Software prerequisite | ||
| Line 53: | Line 41: | ||
|Prerequisite description=MySQL | |Prerequisite description=MySQL | ||
}} | }} | ||
| + | {{Featured}} | ||
Latest revision as of 18:41, 6 December 2017
MySQL Backup
http://worldcommunitypress.com/services/free-opensource-software/
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 (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.
Licensing
License
Verified by
Verified on
Notes
Leaders and contributors
| Contact(s) | Role |
|---|---|
| Peter F. Brown | Maintainer |
Resources and communication
| Audience | Resource type | URI |
|---|---|---|
| Bug Tracking,Developer,Support | mailto:peterbrown@worldcommunity.com |
Software prerequisites
| Kind | Description |
|---|---|
| Required to use | MySQL |
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 or copyright-licenses or other similar notices described in this text has its own copyright notice and license, which can usually be found in the distribution or license text itself.