Welcome to Centmin Mod Community
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

    3,264
    307
    83
    May 31, 2014
    Ratings:
    +566
    Local Time:
    9:49 PM
    Nginx-1.13.x
    MariaDB 10.1.x
    Hello

    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

    39,746
    8,767
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,488
    Local Time:
    4:49 AM
    Nginx 1.15.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
..