mysql_innodb_backup Files

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.

---------------------------------------------------------------------
---------------------------------------------------------------------