1

I am using Percona xtrabackup for creating backup of mysql server. Does backup file includes all the procedures, functions and triggers ? Does it get restored when i restore it ?

1 Answer 1

4

Procedures, functions are stored in mysql database, triggers in respective database directories. XtraBackup makes a copy of all of that.

It however doesn't make a copy of MySQL config file (/etc/my.cnf) you should take care of it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.