ZZEE Active SQL Backup is a software tool that can perform incremental backup of MySQL database.
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.
Version 0.9.2: N/A