[kwlug-disc] how to recover corrupt mysql database from .frm files?
Robert P. J. Day
rpjday at crashcourse.ca
Wed Feb 24 07:11:26 EST 2010
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.
Robert P. J. Day Waterloo, Ontario, CANADA
Linux Consulting, Training and Kernel Pedantry.
Web page: http://crashcourse.ca
More information about the kwlug-disc