[kwlug-disc] how to recover corrupt mysql database from .frm files?

[Robert P. J. Day]

On Wed, 24 Feb 2010, Robert P. J. Day wrote:

>   a colleague asks me if there's a way to recover a mysql database
> that was being hosted by someone else and was apparently corrupted
> in ways that are not at all obvious.
>
>   all the hosting company is providing him with is a tar file of the
> /var/lib/mysql/<db> directory, which consists of nothing but .frm
> files (so it's in innodb format, correct?).  they won't give him the
> ibdata1 file or ib log files, for security reasons.

... snip ...

  one of my first thoughts was whether there's a utility that will
extract from the ibdata1 file and/or the log files *only* the
information that's relevant to this one database.  i suspect the
admins at the hosting company could be persuaded to provide *that*,
once they're convinced that that doesn't represent a security issue.

rday
--

========================================================================
Robert P. J. Day                               Waterloo, Ontario, CANADA

            Linux Consulting, Training and Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday
========================================================================