Hello All,
we have the below setup
Server A → adam_db (LIVE SERVER)
Server B → adam_db (MIRROR SERVER)
on Server A –
we are taking stream backup of adam_db
Step 1:
/usr/bin/innobackupex-1.5.1 --databases=“adam_db” --stream=tar ./ >> /home/DBbackup.tar
Step 2:
copy DBbackup.tar file to Server B
Server B –
Step 1:
tar -ixf /home/DB_backup/DBbackup.tar -C /home/DB_backup/
Step 2:
rsync -trv --exclude=xtrabackup* --exclude=DBbackup.tar --exclude=ibdata1 --exclude=backup-my* /home/DB_backup/* /var/lib/mysql/
Above process fails even we sync ibdata1 file.
Any suggestions?
Regards,
Alok.N