GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

problem with mirroring backup

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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?

    Regards,
    Alok.N

  • #2
    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.

    Comment


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

      Comment

      Working...
      X