Announcement

Announcement Module
Collapse
No announcement yet.

Full MySQL backup without triggers?

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

  • Full MySQL backup without triggers?

    I am looking to do a full innobackupex of every database on the master mysql server, except I would like to remove all triggers from the backup so that they do not get loaded onto the slave server during a restore. Is there a command line option in Xtrabackup that will accomplish this?

    Thanks

  • #2
    innobackupex by default backup triggers too. I don't think there is any option available to skip triggers from backup.

    Comment


    • #3
      Actually I think the following link explains why that probably is not possible. It seems under ROW, removing the triggers is not necessary as they will not fire on the slave when the data is replicated: https://dev.mysql.com/doc/refman/5.1...-triggers.html

      Comment

      Working...
      X