Page 1 of 1

May 22, 2009 Database issues

Posted: Fri May 22, 2009 3:34 pm
by 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 :)

Re: May 22, 2009 Database issues

Posted: Fri May 22, 2009 4:52 pm
by puckstopper
Thanks for fixing it!

Re: May 22, 2009 Database issues

Posted: Fri May 22, 2009 5:12 pm
by chris
Did any data get lost?

Re: May 22, 2009 Database issues

Posted: Fri May 22, 2009 7:38 pm
by mrlayance
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.

Re: May 22, 2009 Database issues

Posted: Fri May 22, 2009 7:42 pm
by chris
Here's what I was seeing:
Picture 1.png
Picture 2.png

Re: May 22, 2009 Database issues

Posted: Fri May 22, 2009 8:10 pm
by mrlayance
chris wrote:Here's what I was seeing:
Picture 1.png
Picture 2.png
Ok, do you still see that?

Re: May 22, 2009 Database issues

Posted: Fri May 22, 2009 9:58 pm
by chris
No. Now it's fine. Just wanted you to have a record of it.