Full MySQL backup without triggers?

[bexicusmaximus]

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

[mirfan]

innobackupex by default backup triggers too. I don’t think there is any option available to skip triggers from backup.

[bexicusmaximus]

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: [url]https://dev.mysql.com/doc/refman/5.1/en/replication-features-triggers.html[/url]