problem with mirroring backup

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?


I don’t see where you say what the failure is, but I’m guessing that MySQL won’t start. I suggest you RTFM because it looks like you haven’t prepared the backup.

Could you let us know how can we create an ibdata1 file for a single database.