Not the answer you need?
Register and ask your own question!

Restore fullbackup using different path specified in my.cnf

BoadriusBoadrius EntrantInactive User Role Beginner
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

Comments

  • sayeedanassayeedanas Entrant Current User Role Contributor
    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.
  • BoadriusBoadrius Entrant Inactive User Role Beginner
    Thank you so much sayeedanas. It was very useful :)
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.