PunBB

Full Version: May 22, 2009 Database issues
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Everything should be back in order. Thanks for all the email, I hate using my cell phone for replying to emails, takes way too long. I need a crackberry or iphone. Not sure what happened but a table of the DB became corrupt.

/ nerd content on

Looks like the phpbb_topics_watch.myi file became corrupt and the header of the phpbb_post.myi header was missing.

I was getting 22 when fixing table errors when running repair from phpmyadmin.

Had to run a some mysql command manually.

Here is a good tutorial on corrupt mysql db's.

<!-- m --><a class="postlink" href="http://www.databasejournal.com/features/mysql/article.php/10897_3300511_2/Repairing-Database-Corruption-in-MySQL.htm">http://www.databasejournal.com/features ... -MySQL.htm</a><!-- m -->

/ nerd content off

Now off to my bathroom painting... I would much rather do this Smile
Thanks for fixing it!
Did any data get lost?
chris Wrote:Did any data get lost?

No data was lost. The table was fine, just the file that basically one of the files that links all the other tables together was corrupt. Only affecting one part of the database. That is why you could still read the posts just not add to or create new posts.
Here's what I was seeing:
[attachment=82]
[attachment=83]
chris Wrote:Here's what I was seeing:
[ATTACHMENT NOT FOUND]
[ATTACHMENT NOT FOUND]

Ok, do you still see that?
No. Now it's fine. Just wanted you to have a record of it.