[PLUG] Mysql db recovery problems
Paul Heinlein
heinlein at madboa.com
Thu Feb 21 19:48:07 UTC 2008
On Thu, 21 Feb 2008, Rogan Creswick wrote:
> I recently had some disk corruption on a low-priority personal
> server (in other words, a box that I didn't bother backing up
> regularly, and never stored anything critical on.) I would like to
> recover my wiki if possible, though, and this is proving to be
> difficult.
>
> The wiki was a mediawiki install that used Mysql 4.1 for the data
> storage, but the version installed now is 5.0.51-3. The machine is
> running debian testing, but I don't think that makes much
> difference.
>
> Mysql will load the database, and I can see the tables with SHOW
> TABLES; however anything that tries to actually look at a table in
> detail errors out with some form of "table does not exist". An
> exerpt of the output from mysqlcheck is below, which demonstrates
> this: (CHECK TABLE <table> seems to do the same thing, just from
> within mysql)
Do you have access to a box with mysql 4.1 (or higher in the 4.x
series)? If so, I'd try using that version of mysqldump to create
straight test/SQL versions of your data. Then use mysql 5 to load the
dumped data.
Or maybe you've tried that already...
--
Paul Heinlein <> heinlein at madboa.com <> http://www.madboa.com/
More information about the PLUG
mailing list