List:General Discussion« Previous MessageNext Message »
From:Robert P. J. Day Date:July 28 2010 9:23am
Subject:might need some help recovering tables from trashed DB
View as plain text  
  i asked about this once upon a time, and might need a little more
help here.  a friend's mysql hosting provider lost an entire DB, but
has managed to recover and hand over the "ibdata1" file (or at least
some portion of it).

  when my friend popped into mysql, what he's seeing is that some of
the tables appear to be back, but others generate a "does not exist"
diagnostic.  by way of trying to help last time, i literally copied
the underlying mysql files onto my linux system, then fired up mysql
to see what magically appeared, but that was before i even had the
ibdata1 file so i wasn't surprised to get very little in the way of
recovered data.

  now, though, with this ibdata1 file, i can try that again -- fire up
a new linux box, and manually install the files under /var/lib/mysql.
i'm guessing i'll see much of what he's seeing.  i just want to verify
that, if that's all i have access to and some of the tables still
appear to be missing, there's not much i can do.  or is there?

rday

-- 

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

        Top-notch, inexpensive online Linux/OSS/kernel courses
                        http://crashcourse.ca

Twitter:                                       http://twitter.com/rpjday
LinkedIn:                               http://ca.linkedin.com/in/rpjday
========================================================================
Thread
might need some help recovering tables from trashed DBRobert P. J. Day28 Jul