Not the answer you need?
Register and ask your own question!

Step by step MariaDB move from one server to another

SmallBatSmallBat EntrantCurrent User Role Beginner
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?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.