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 ?
Mysql – Routines backup in Percona xtrabackup
backupMySQLpercona
Related Question
- Mysql – percona xtrabackup to backup thesql database
- Mysql – Cannot overwrite file: /var/lib/thesql/ibdata1 when using Percona xtrabackup
- Mysql – Percona Xtrabackup (Partial + incremental)
- Mysql backup of remote server in local machine using percona xtrabackup
- Mysql – Xtrabackup corrupt incremental backup
- Mysql – Incremental backups: MySQL Enterprise Backup vs Percona XtraBackup
- MySQL – Restoring Master/Slave Replication from Percona Backup
Best Answer
Procedures, functions are stored in
mysqldatabase, 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.