I have a database that is constantly growing, so I must take great care of these records.
I was looking on the internet and Oracle Corporation (owner of MySQL since 2010) provides a paid product, MySQL Enterprise Backup , to perform this type of backup with one command, mysqlbackups
.
An example of use:
mysqlbackup --backup-image=/backups/sales.mbi --backup-dir=/backup-tmp backup-to-image
With this tool there is a way to perform incremental backup and perform differential backup.
My question basically is: How to perform an incremental or differential backup with basic MySQL commands?