ZZEE Active SQL Backup can perform *incremental* backup of MySQL database.
Version: 0.9.2Since MySQL is the most popular SQL server that is used in conjunction with web sites, there was a need for incremental backup utility. ZZEE Active SQL Backup is designed for clients of web hosting companies, and can be useful to system administrators as well.
License: Proprietary License
Operating System: Linux
Here are some key features of "ZZEE Active SQL Backup":
· Can perform *incremental* backup of MySQL database
· Can perform full backup of MySQL database
· Can replicate database
· Can process SQL queries
· Can dump database structure
· Can suggest database changes needed to process incremental backup
· Can send data backed up by email
· Can transfer backed up data by FTP to other computer (if Net::FTP is installed)
· Can compress backed up data
Active SQL Backup can do incremental or full backups of MySQL database as often as needed. It is suitable both for the clients of web hosting companies who can not get access to MySQL update logs and for the host administrators. Backup syntax is:
shell> ./zmdb.pl -b
It stores backup files in BACKUP_DIR, specified in user_settings.txt, named like YYYY_MM_DD_hh_mm_ss.sql[.gz]. The backup files consist of series of SQL INSERT statements and may contain DELETE statements. The database scheme is stored in file database_name.create.sql. If gzip is available, then Active SQL Backup automatically uses it to compress stored data. The program can automatically send backed up files by email or upload to the other computer by FTP.
If the system fails, Active SQL Backup can restore the database. Restore syntax for incremental backups is:
shell> ./zmdb.pl -r
If you make full backups, restore syntax is the following:
shell> ./zmdb.pl -e < BACKUP_DIR/database_name.create.sql
shell> ./zmdb.pl -e < BACKUP_DIR/YYYY_MM_DD_hh_mm_ss.sql &
The first line is needed to restore database structure, and the second is the *most recent* data file. You may need to "gunzip" it before supplying to restore.
You can use the program to dump database structure
shell> ./zmdb.pl -s > structure_dump_file
or to process queries. The latter feature is useful if you need to process queries regularly, for example, to update membership status of the users of your online service. The syntax to execute SQL queries is:
shell> ./zmdb.pl -e < some_sql_file
Where format of some_sql_file is the same as with Mysql utility: SQL statements are separated by semicolon. Note that if you pass SELECT queries to Active SQL Backup, then no result will be returned.
Syntax summary is:
- a --advice suggest database modifications and tables_config.txt
- b --backup backup database structure and data
- e --execute execute SQL queries [from STDIN]
- h --help print this screen
- r --restore restore database structure and data
- s --structure dump database structure [to STDOUT]
· Perl 5
· Perl Msql-Mysql modules
· Optionally: gzip, nice, sendmail
· Optionally: mysql utility
· Optionally Perl Net::FTP module