DB CRASH! OH NO!

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
rj
Regular
Posts: 477
Joined: Sun Sep 10, 2006 2:53 pm

DB CRASH! OH NO!

Post by rj »

I did a RESTART SERVER as I do often but this time the results are a SQL CRASH.
As I now have a Dedicated Server at Godaddy they are ZERO help.
The crash info seems to be presented in depth instead of the blog.

http://rackjite.com

But this seems to be the gist of it

/ Table './kick/serendipity_config' is marked as crashed and should be repaired

Going into PHPmyadmin I find the table EMPTY and cannot find any REPAIR option.
I do have daily DB backups on the server but doing that I lose about 5 hours of article work this morning... Is repair possible and how do you do it?
And to apply a backup, is that under IMPORT or something else?

Help please!

Thanx RJ
Last edited by rj on Wed Jan 25, 2012 4:38 pm, edited 1 time in total.
kleinerChemiker
Regular
Posts: 765
Joined: Tue Oct 17, 2006 2:36 pm
Location: Vienna/Austria
Contact:

Re: DB CRASH! OH NO!

Post by kleinerChemiker »

If you have phpmyadmin you can select this table and use the repair.
rj
Regular
Posts: 477
Joined: Sun Sep 10, 2006 2:53 pm

Re: DB CRASH! OH NO!

Post by rj »

thanx! It tells me the table is empty and I see no REPAIR option.
I think I may have clicked the EMPTY button expecting more options than just it emptying :)

So I assume my only option is to use the backup.sql file?

In phpmyadmin...
If I bring up all the tables, then click the box for serendidity_config which now says IN USE, and then import the dbfile. Will it just import that one table I need? Is that what I should do? The whole SQL file is 35 megs.

thanx RJ
kleinerChemiker
Regular
Posts: 765
Joined: Tue Oct 17, 2006 2:36 pm
Location: Vienna/Austria
Contact:

Re: DB CRASH! OH NO!

Post by kleinerChemiker »

Did you do the backup with phpmyadmin? If so, I would import it into a _new_ DB, export only the config table and import this into you blog.
Post Reply