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?)
We build. You grow.
Get best community software hereStart a social network, a fan-site, an education project with oxwall - free opensource community software
db tables corrupt. | Forum
Leader
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!
Pls help!
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.
All is well with the world.
Team
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!
If you are serious about websites, I cannot stress enough… BACKUP!
Aqsa Bibi
Aug 25 '24
It sounds like you’re dealing with a tricky database issue. If a repair isn’t fixing the corruption and a restore would cause you to lose content, your idea of restoring to a previous state and then applying a data import could be a viable solution. This approach allows you to recover from the backup while preserving your latest data.
Before proceeding, make sure to back up your current data as well. After restoring, you can import the data export you have, ensuring that the most recent content is preserved. If this method doesn’t work, consulting with a database specialist might be necessary.
On a different note, if you’re in need of a service unrelated to tech, such as addressing paintless dent repair denver colorado, local experts can assist you with any vehicle issues you might have.
