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
DB CRASH! OH NO!
DB CRASH! OH NO!
Last edited by rj on Wed Jan 25, 2012 4:38 pm, edited 1 time in total.
-
- Regular
- Posts: 765
- Joined: Tue Oct 17, 2006 2:36 pm
- Location: Vienna/Austria
- Contact:
Re: DB CRASH! OH NO!
If you have phpmyadmin you can select this table and use the repair.
Re: DB CRASH! OH NO!
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
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
-
- Regular
- Posts: 765
- Joined: Tue Oct 17, 2006 2:36 pm
- Location: Vienna/Austria
- Contact:
Re: DB CRASH! OH NO!
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.