1.10.1

Added support for mariadb-dump instead of mysqldump wich deprecated in MariaDB 11.0.1

New in 1.10.0
Added support for daily backups for each day of month

1.9.2

Added --ignore-missing-args to rsync for suppress vanished files warnings.

1.9.1

Fixed files exclusion with ssh protocol

1.9.0

Added support for sorting backups by subdirectories.

Set SORT_BACKUPS var as true in backup.conf if you want sort backups by subdirectories in cloud (files for files, databases for databases; disabled by default).

1.8.1

Added retrying create DB dump if mysqldump fail in --single-transaction mode with error like this: mysqldump: Error 1412: Table definition has changed, please retry transaction when dumping table ....

It occurs when using ALTER TABLE, CREATE TABLE, DROP TABLE, RENAME TABLE, or TRUNCATE TABLE during dumping. The script will be retry dumping with disabled --single-transaction mode.

Now the script will be generate warning in log with this error. Change backup time to another if you often see this warning.

1.8.0

• added support for logging;
• added new var SCRIPT_LOG_PATH for set full path to log (logging disabled if it not defined);
• added escaping special characters ans spaces in values of sensitive vars;
• more data checks;
• fixed output coloring and styles;
• a lot of bugfixes;
• small refactoring.

1.7.0

• added support for backups via SSH (rsync);
• added new vars into backup.conf for ssh connection;
• added parameter for backup via only specified protocol;
• bugfixes.

1.6.2

• added new parameters to mysqldump command (--insert-ignore, --skip-lock-tables, --single-transaction=TRUE, --add-drop-table);
• added gzip compression during database dump.

1.6.1

Fixed archive filename for hourly backup period.

Old filename - <project_name>_<backup_type>_<week_day_number>_<week_day_name>_<hour>.7z
New filename - <project_name>_<backup_type>_hourly_<hour>.7z

1.6.0

• Added hourly backup period;
• Added parameters for excluding folders for hourly backup period:
  • HOURLY_EXCLUDE
  • HOURLY_EXCLUDE_RELATIVE