mylvmbackup-discuss team mailing list archive
Mailing list archive
Restore MySQL DB from mylvmbackup?
Backups of MySQL innodb databases are taken using mylvmbackup and the
resulting backup contains the whole mysql folder as per example below:
The following recover option is used with mylvmbackup
recoveryopts=--skip-networking --skip-grant --bootstrap --skip-syslog
MySQL is configured to use innodb_file_per_table.
We have a client that would like a .sql dump file from the "database1"
backup. The database1 folder contains .frm, .ibd files and a db.opt
file. Restore preference is without stopping MySQL as we have other
databases in use but if there is no other way then a small downtime
would be ok.
Various research suggests I need to recover the ibdata1 file along
with the DB but I'm concerned changes to this file will affect the
other live databases on the server.
What is the easiest way to do this?
N.B. I posted this question on dba.stackexchange.com but I'm posting
here as well in hope of an answer.