Hi, I’m trying to do an incremental restore and I’m a bit confused.
What I’ve done:
I have two systems Prod and Dev. I made a full backup of the Prod db about 2 weeks ago. I copied that backup to the Dev system and successfully restored it, with no issues. Now I want to use an incremental backup to bring Dev up to date with Prod and then start replication.
I’ve started with a clean system by deleting the Dev db and again doing the full backup restore. I have not yet restarted the Dev db. I then ran an incremental backup on Prod, setting --incremental-lsn to the value of to-lsn from the xtrabackup_checkpoints file (because that backup is on the Dev server and is no longer available on the Prod server. The incremental backup completed and I’ve copied it to the Dev system.
Where I’m confused:
The docs seem to want me to apply the incremental backup to the base backup dir but I don’t want to mess up my full backup - it takes 8 hours to get that from tape. I just want to apply the incremental to the newly restored db. Remember, I have not restarted mysql after the full backup restore - can’t I just copy the incremental to the /var/lib/mysql dir and startup? I need to keep the original full mysql backup untouched in case I have to do this again.
Any suggestions or ideas would be greatly appreciated,