Name | Modified | Size | Downloads / Week |
---|---|---|---|
Z_THANKS.txt | 2010-06-11 | 2.2 kB | |
Z_REVISION_HISTORY.txt | 2010-06-11 | 2.1 kB | |
Z_README.txt | 2010-06-11 | 4.2 kB | |
Z_LICENSE.txt | 2010-06-11 | 35.1 kB | |
mysql_innodb_backup_v-0-2_2010-0603_PUBLIC.tar | 2010-06-11 | 71.7 kB | |
Totals: 5 Items | 115.3 kB | 0 |
mysql_innodb_db_backup --------------------------------------------------------------------- # ... quick and dirty backup for InnoDB engine driven mysql db's --------------------------------------------------------------------- --------------------------------------------------------------------- COPYRIGHT THE FOLLOWING 10 LINES MAY NOT BE REMOVED, but may be appended with additional contributor info. mysql_innodb_db_backup Copyright (C) 2009, 2010 V. Spinelli for Sorrento Lactalis American Group This program comes with ABSOLUTELY NO WARRANTY; As this program is based on [and has dependancies] the content of GPL and LGPL works, GPL is preserved. This is open software, released under GNU GPL v3, and you are welcome to redistribute it, with this tag in tact. ... http://www.sorrentolactalis.com ... http://www.spinellicreations.com A copy of the GPL should be included with this work. If you did not receive a copy, see... http://www.gnu.org/licenses/gpl-3.0.txt --------------------------------------------------------------------- --------------------------------------------------------------------- CONTACT Author V. Spinelli Email: Vince@SpinelliCreations.com Site: http://spinellicreations.com Handle: PoweredByDodgeV8 Copyright Holder Sorrento Lactalis American Group Email: http://www.sorrentocheese.com/about/contact.html Site: http://www.sorrentolactalis.com --------------------------------------------------------------------- README... --------------------------------------------------------------------- --------------------------------------------------------------------- REQUIREMENTS ------------ 1- Python version 2.5 or greater (http://python.org) 2- py-setproctitle library version 1.0 or greater (http://pypi.python.org/pypi/setproctitle) 3- Linux (Preferred) / Unix / BSD / Windows ... whatever ... INSTALL ------- 1- unzip / untar the package and copy to ... - /opt/mysql_innodb_backup - c:\mysql_innodb_backup 2- edit the global options file (./options/options.opt)... - FLAVOR -- -- WIN or UNIX - BACKUPROOT -- -- top folder tree where your backups will be held -- -- example: c:\backups -- -- example: /opt/backups - TEMPDIR -- -- temporary directory for backups in progress -- -- example: temp (implies c:\backups\temp or /opt/backups/temp) - BACKUPDIR -- -- final destination for backups once complete -- -- example: full (implies c:\backups\full or /opt/backups/full) - REVISIONCOUNT -- -- how many backups do we store before we start deleting the -- -- oldest ones? -- -- example: 5 (allows us to keep 5 backups before the first is trashed) - UNIQUEID -- -- server name or other unique identification -- -- example: PentiumSlayer1 - CHARSET -- -- MySQL character set declaration -- -- example: Latin1 -- -- example: utf8 - DBUSERNAME -- -- root database username - DBPASSWORD -- -- root database user's password - PATHTOMYSQL -- -- path to mysql executable -- -- c:\mysql\bin\mysql.exe on WIN FLAVOR -- -- /usr/bin/mysql on UNIX - PATHTOMYSQLDUMP -- -- path to mysqldump executable -- -- c:\mysql\bin\mysqldump.exe on WIN FLAVOR -- -- /usr/bin/mysqldump on UNIX - DATABASES -- -- space separated list of databases on server to backup -- -- example: mydb1 (backs up only mydb1 database) -- -- example: mydb1 mydb2 mydb3 (backs up mydb1, mydb2, and mydb3) BACKUP ------ 1- simply call "mysql_innodb_backup.py BACKUP" and your database(s) will be backed up. RESTORE ------- 1- create a fresh database server instance on the localhost 2- setup a root user and pass for the server 3- install mysql_innodb_backup and edit config file 4- call "mysql_innodb_backup.py RESTORE [filename.sql]" -- example: c:\python\python.exe mysql_innodb_backup.py RESTORE SERVER_DUMP_2009-12-01.sql -- all databases backed up inside of filename.sql will be dumped to the new server instance. HELP ---- 1- simply call "mysql_innodb_backup.py HELP" and the help dialogue will popup. --------------------------------------------------------------------- ---------------------------------------------------------------------