I’m following these steps to backup a database only:
To backup the database I do:
innobackupex --user=root --databases='database' /home/user/innobackupex
Preparing the backup:
innobackupex --apply-log --export /home/user/innobackupex
then to copy all the files the the file directory I do:
rsync -avrP /home/user/innobackupex /var/lib/mysql/
MY database got restored but when I try to list my functions they are gone! SHOW FUNCTION STATUS
Now, if I tried to do a full backup this does’t happen.
Any idea why this is happening?