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

[Khalid Baheyeldin]

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
> contract?
>
> Seems to me the benefits of having databases professionally hosted are
> business continuity, high availability, data integrity, &c...


Very true.

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
2bits.com, Inc.
http://2bits.com
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...
URL: <http://kwlug.org/pipermail/kwlug-disc_kwlug.org/attachments/20100224/7b9c57de/attachment.htm>