Not the answer you need?
Register and ask your own question!

Full MySQL backup without triggers?

bexicusmaximusbexicusmaximus EntrantInactive User Role Beginner
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

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.