Hello Community
I want to do an incremental backup between 8 - 18 o’clock every 2 hours.
But the problem is while the backup is running the data will be locked and the user can’t work.
In the database i have just innodb tables.
I run the script with the followed parameters:
innobackupex --user="$MYSQL_USER" --password="$MYSQL_PASS" --no-lock --incremental --incremental-basedir="$LAST_BACKUP" "$INCREMENTALS_DIRECTORY
I have no replication server.
Is it possible to do a hotbackup whitouht a replication server?
Do execute the backup-script with the correct parameter or some ohter mistakes?
Thanks for your help.
Christoph