ZZEE Active SQL Backup 0.9.2 review

Since MySQL is the most popular SQL server that is used in conjunction with web sites, there was a need for incremental backup utilit

License: Other/Proprietary License File size: 22K Developer: ZZEE

0

Since 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.

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

Usage synopsis

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:

zmdb.pl [SINGLE_OPTION]
-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]

Requirements:
Perl 5
Perl Msql-Mysql modules
Optionally: gzip, nice, sendmail
Optionally: mysql utility
Optionally Perl Net::FTP module