I need to move my DB from old server to new one. Downtime is not much sensitive for me.
So I made a backup on old server:
xtrabackup --backup --datadir=/var/lib/mysql/ --target-dir=/data/backups/base/
Next I prepare it:
xtrabackup --prepare --apply-log-only --target-dir=/data/backups/base
Next I copied backup to new one:
rsync -zavP user@192.168.0.1:/data/backups/base /backup/some/dir/on/new/server
… some time passed … (7-8 hours) database is pretty big one Now I need incremental backup for this 7-8 hours I do incremental backup on old server:
xtrabackup --prepare --apply-log-only --target-dir=/data/backups/base --incremental-dir=/data/backups/inc1
What should I do next? My assumption is: 1. Copy incremental backup, and apply it in base and do
xtrabackup --copy-back --target-dir=/backup/some/dir/on/new/server
OR 2. Apply base backup without incremental and THEN apply incremental backup?