ZZEE Active SQL Backup ZZEE Active SQL Backup can perform *incremental* backup of MySQL database.
Download

ZZEE Active SQL Backup Ranking & Summary

ZZEE Active SQL Backup Tags

database SQL backup MySQL backup incremental backup SQL backup

ZZEE Active SQL Backup Description

ZZEE Active SQL Backup can perform *incremental* backup of MySQL database. 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 dataUsage synopsisActive 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 -bIt stores backup files in BACKUP_DIR, specified in user_settings.txt, named like YYYY_MM_DD_hh_mm_ss.sql. 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 -rIf 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_fileor 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_fileWhere 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 -a --advice suggest database modifications and tables_config.txt-b --backup backup database structure and data-e --execute execute SQL queries -h --help print this screen-r --restore restore database structure and data-s --structure dump database structure Requirements:· Perl 5· Perl Msql-Mysql modules· Optionally: gzip, nice, sendmail· Optionally: mysql utility· Optionally Perl Net::FTP module

ZZEE Active SQL Backup Related Software