May 22, 2009 Database issues

[mrlayance]

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.

http://www.databasejournal.com/features ... -MySQL.htm

/ nerd content off

Now off to my bathroom painting... I would much rather do this

[puckstopper]

Thanks for fixing it!

[chris]

Did any data get lost?

[mrlayance]

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.

[chris]

Here's what I was seeing:

Picture 1.png

Picture 2.png

[mrlayance]

Here's what I was seeing:

Picture 1.png

Picture 2.png

Ok, do you still see that?

[chris]

No. Now it's fine. Just wanted you to have a record of it.