Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
May 22, 2009 Database issues
#1
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
I need 2 Kingston Tickets, please help.
Reply
#2
Thanks for fixing it!
Reply
#3
Did any data get lost?
Reply
#4
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.
I need 2 Kingston Tickets, please help.
Reply
#5
Here's what I was seeing:

.png   Picture 2.png (Size: 30.82 KB / Downloads: 16)

.png   Picture 1.png (Size: 35.96 KB / Downloads: 18)
Reply
#6
chris Wrote:Here's what I was seeing:
[ATTACHMENT NOT FOUND]
[ATTACHMENT NOT FOUND]

Ok, do you still see that?
I need 2 Kingston Tickets, please help.
Reply
#7
No. Now it's fine. Just wanted you to have a record of it.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)