4

I am running a few restore tests on my Dev and I've noticed that the stored routines are not being restored with the innobackupx. Is that something achievable ? Am I doing something wrong ?

I am only using innodb tables so it will be good to restore the db using only innobackupx.

Thank you.

Community
  • 1
Haohmaru
  • 145
  • 1
  • 7

2 Answers2

5

Stored procedures are stored in database mysql. Innobackupex copies it by default. Make sure database mysql is restored with other databases.

akuzminsky
  • 4,997
  • 15
  • 16
3

In order to take the backup of MySQL Server Objects i.e routines / triggers / events you can do like below

mysqldump -h$MySQLHost -u$YourUser -p$YourPassword --no-data --no-create-info --routines --triggers --events $Database > MySQLStoredProcedures.sql

The above will backup only the database objects , no data , no create table etc.

Abdul Manaf
  • 9,587
  • 16
  • 73
  • 84