[kwlug-disc] how to recover corrupt mysql database from .frm files?
kb at 2bits.com
Wed Feb 24 10:57:43 EST 2010
On Wed, Feb 24, 2010 at 10:48 AM, Bob Jonkman <bjonkman at sobac.com> wrote:
> 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.
> Can your colleague ask the hosting company to "restore the database" to the
> state it was X number of days ago? Was backup and restore part of their
> Seems to me the benefits of having databases professionally hosted are
> business continuity, high availability, data integrity, &c...
But even with that, I have cron scripts that do daily dumps of the data base
for clients and instruct them to download them at least once a week, if not
every day, and keep it on another server. This way there is some recourse if
there is such a catastrophe or the hosting company goes out of business.
Khalid M. Baheyeldin
Drupal optimization, development, customization and consulting.
Simplicity is prerequisite for reliability. -- Edsger W.Dijkstra
Simplicity is the ultimate sophistication. -- Leonardo da Vinci
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the kwlug-disc_kwlug.org