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 ?


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, privacy policy and cookie policy

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