mylvmbackup-discuss team mailing list archive
-
mylvmbackup-discuss team
-
Mailing list archive
-
Message #00014
Re: Adding --innodb-file-per-table
Adding that variable will only affect tables that are created/altered after
it's added or taken away.
I could be reading the below wrong, but, if what you're asking is, what will
happen to backups/logs, basically the answer is nothing.
The innodb log files are for all innodb tables (whether that
innodb-file-per-table variable is added or not), as are the binlogs. As for
the tables, they'll be backed up as normal, whether in a separate file, or
in the combined tablespace.
But, I could be completely misunderstand the question.
Michael
-----Original Message-----
From: mylvmbackup-discuss-bounces+michael=sykosoft.com@xxxxxxxxxxxxxxxxxxx
[mailto:mylvmbackup-discuss-bounces+michael=sykosoft.com@xxxxxxxxxxxxxxxxxxx
] On Behalf Of Boehm, Matthew
Sent: Monday, February 02, 2009 10:14 AM
To: Tim Stoop
Cc: mylvmbackup-discuss@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Mylvmbackup-discuss] Adding --innodb-file-per-table
Oh I see what you are saying now. Sorry, no coffee yet. I have no idea
what InnoDb will do when doing recovery on a system that had
file-per-table flag but doesn't have it now. Experimentation/proof is
needed that it won't affect those of us that are not using
file-per-table.
-Matthew
References