HEADER
QUOTE I would love to change the world, but they won't give me the source code.

- Unknown
QUOTE

Project Codename: MySQL_InnoDB_Backup

PROJECT_SPLASH

Download

DOWNLOADDOWNLOAD[ v-0-2_2010-0603_PUBLIC ]
HTTP -- Download.SpinelliCreations.com/MySQL_InnoDB_Backup


FTP -- SpinelliCreations.com/mysql_innodb_backup

Project Description

Description

mysql_innodb_backup is a python package that facilitates the (redundant) backup of InnoDB based databases to file.

Haunted by fears of data loss, and strongly opposed to the 'accepted' method of hosting two database servers (the primary and backup) - then syncing the backup database and dumping it to file; mysql_innodb_backup was created to allow on-the-fly backup of live running InnoDB based MySQL databases to file.

Run daily as a scheduled job (cron or task-scheduler, or another job-scheduling method of your choice; heck, you can even call it manually), mysql_innodb_ backup will not only dump your existing chosen databses to file, but it will also keep a backlog for 'X' number of days. For example, if you wish to go back 5 days, you can have mysql_innodb_backup dumb today's backup to file, and then keep yesterday's, the day before that's, and so on - for five days. Tomorrow, the oldest file will be deleted, all other files will be incremented, and the latest file will be saved.

Language

python - v2.5

Syntax

./mysql_innodb_backup.py [FUNCTION] [FILENAME (RESTORE only)]

Functions

BACKUP
-- automated backup based upon choices in configuration / options file.

RESTORE [FILENAME.sql]

-- automated restore based upon choices in configuration / options file.
-- must supply filename.sql backup file containing data with which to rebuild databases.

Examples

[you@localhost]# python mysql_innodb_backup.py BACKUP
-- automated backup based on config / options file.

[you@localhost]# python mysql_innodb_backup.py RESTORE my_backed_up_database_file.sql
-- automated restore based on config / options file, using data from my_backed_up_database_file.sql file.

Screen Captures and Related Images

SCREEN_CAP SCREEN_CAP

terminal: 'help'

editing 'options.opt' file in VIM



Built: Oct. 25, 2010
Updated: Nov. 2, 2010