ZZEE Active SQL Backup

ZZEE Active SQL Backup is an important tool for those who use MySQL as their SQL server with web sites. This software is helpful for the clients of web hosting companies, as well as system administrators. Its key feature is the ability to perform either incremental or full backup of MySQL database. This software can also replicate database, process SQL queries, dump database structure, suggest database changes needed to process incremental backup, send data backed up by email, transfer backed up data by FTP to other computers, and compress backed up data.

ZZEE Active SQL Backup can be used for both full and incremental backups of MySQL database. It stores backup files in BACKUP_DIR, specified in user_settings.txt, and display them as YYYY_MM_DD_hh_mm_ss.sql[.gz]. This software automatically uses gzip to compress the backup files if gzip is available. Furthermore, ZZEE Active SQL Backup can restore the database if the system fails. It also can dump database structure or process queries.

Users can use this software to execute SQL queries, which is helpful when regularly updating the membership status of their online service. The syntax to execute SQL queries is similar to that of Mysql utility: SQL statements are separated by semicolon. It is important to note that if you pass SELECT queries to Active SQL Backup, then no result will be returned.

The software can be run with several options, including advice, backup, execute, help, restore, and structure. ZZEE Active SQL Backup requires Perl 5, Perl Msql-Mysql modules and optionally gzip, nice, sendmail, mysql utility, and Perl Net::FTP module.

Overall, ZZEE Active SQL Backup provides efficient and reliable MySQL database backup and restore tools, among several other useful features. Its user-friendly interface and straightforward syntax make it an excellent software tool for both web hosting clients and system administrators.