Join the community today
Become a Member

Backup database and then get only new data per hour

Discussion in 'MariaDB & General MySQL news & discussions' started by pamamolf, Mar 12, 2019.

  1. pamamolf

    pamamolf Premium Member Premium Member

    May 31, 2014
    Local Time:
    6:55 AM
    MariaDB 10.3.x

    Does anyone knows/use any script that can get a database backup and then get only the new data per hour as backup and at the end be able to restore at any hour?

    Thank you
  2. eva2000

    eva2000 Administrator Staff Member

    May 24, 2014
    Brisbane, Australia
    Local Time:
    1:55 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    MySQL can do that natively for InnoDB tables at least with InnoDB binary logging (also used for MySQL replication) and rollback which you can configure and setup if you know what you're doing. Read up on InnoDB binary logging which is usually the MySQL default enabled but disabled by folks and Centmin Mod as it uses up alot of disk space - busy/large MySQL data set can use 100s of gigabytes of extra disk space doing InnoDB binary logging.

    Alternatives for incremental backups also include mydumper and Percona's Xtrabackup or MariaDB's own fork MariaBackup Mariabackup

    • Informative Informative x 1