Restore fullbackup using different path specified in my.cnf

Hi everybody,

I want to restore a full backup using innobackupex but I would like to use to restore the database a different path specified in my.cnf ‘var/lib/mysql’. Is it possible specify other path without --copy-back?

Thank you.

Best regards,
Boadrius

Yes Boadrius, it is possible, only you need to define your my.cnf path while taking backup via innobackupex like below

innobackupex --defaults-file=/etc/my_anon.cnf – XXXXXXX

Hope it will be helpfull for you.

Thank you so much sayeedanas. It was very useful :slight_smile: