Page 1 of 1

DB CRASH! OH NO!

Posted: Wed Jan 25, 2012 4:14 pm
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

Re: DB CRASH! OH NO!

Posted: Wed Jan 25, 2012 4:21 pm
by kleinerChemiker
If you have phpmyadmin you can select this table and use the repair.

Re: DB CRASH! OH NO!

Posted: Wed Jan 25, 2012 4:43 pm
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

Re: DB CRASH! OH NO!

Posted: Wed Jan 25, 2012 9:09 pm
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.