We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

db tables corrupt. | Forum

Michael Leader
Michael Feb 1 '11
My host had to do some work on the site to resolve pdo exception errors.

Now the site is up but unfortunately I have corruption in my db. A repair doesn't fix.

Attached is a list of checks on the db.

Is there any way I can fix this without doing a previous restore and losing content?
(I have done a data export and was thinking, can I do a previous restore then apply a data import?)

Attachments:
  oxwall.txt (5.96Kb)
Michael Leader
Michael Feb 1 '11
currently my search members is broke and also most likely the advertisement plugin although I am not using it.

Pls help!
Michael Leader
Michael Feb 1 '11
ignore this. I was able to restore the table content from a previous night's backup.

All is well with the world.
Den Team
Den Feb 1 '11
You are a lucky man Michael. (if you have backups of course :))
Michael Leader
Michael Feb 2 '11
Was very lucky it was not a date sensitive data field. I think it was caused by my PDO exception. I am now looking into hourly backups! ANd of course looking for oxwall to maybe adopt an idea for this in the admin panel?

If you are serious about websites, I cannot stress enough… BACKUP!