DISQUS

Alright. You were right!

Apparently when I repaired or restored the table...it really repaired the issue! I went back and piece by piece began editing pages. I was nervous and made a backup beforehand. It took!

I really do need to edit the pages also because apparently upon repair or the restore [I am not sure which] it added a lot of ? [question marks] to random areas. I corrected the most recent posts of this.

Thanks for all of your help. And now I am not scared to edit my posts thanks to your question. LoL...Still. I need to get my blog moved to the domain I got and update my WordPress.

I am also now a member of your MyBlogLog community so I can <strike>stalk</strike> follow your blog. :-)

I never heard of a table crash when editing a post before.

Tell me about it!

Let me give you the specs. WP 2.0.6 [Don't laugh! :P] I'll have to see if it happens again after restoring the table. It wasn't a "blog post" per se...but was a page off the parent. [This page: Resources.]

I needed to update some information. It may turn out whacked because I'm going in to test editing it to see if it yields a crash. If you watch you may be able to see it. ...oh and of course....when it crashes [although it references only the one table as being crashed and in need of repair...the entire site goes down and I get 404's sitewide.

http://samsara.ihostyou.com

I used myisamchk because I did read time and time again from various tech -related resources that to use_frm was a baddie if you'd previously built your tables with one version and then got upgraded - which was my case.

In my case I was built and contrived on mySQL 4 and then host went to v. 5. There was no issue until an edit. When I edited a page...it was like the Wordpress 'E bomb' exploded.

I utilized your suggestion and all was well.

Then I went back to edit again and again...it happened. This time no commands were working. I restored a backup table and that was a success. Currently my server tech's are looking into it. My version of WP is so old my grandmother was wearing black and white clothes when it came out...so I am thinking it's an incompatibility with mySQL 5 that's causing the original crashes.

I'll keep you posted if you like. If other people find this nice post under similar circumstances they may be interested to hear any solution I find?

This post saved my life. [Ironic you posted it on my birthday!]

My server is in [was] in the middle of an upgrade from mySql 4 to mySQL 5. I like that you offer your own experience. I tried your suggestion and was successful. Now if I can just keep that table [wp_posts] from crashing everytime i try to now alter a post... hopefully the server's being worked on and it has to do with the upgrade though my mySQL knowledge is limited.

Thanks for this. I Stumble thumbed it up! I'll be back! Fabulous.

{{Dolly}}

I am so sorry for your loss and am so happy to hear Dolly's last hours were filled with the love and attention she got from you. She was your friend and very loved.

Sorry to meet you under this topic but I was moved as I found your blog. I love this. I lost my Naji this time last year and she was 9. Was in the middle of a crazy time in my life and I still mourn her.

Thank you for sharing this part of your life. SO nice to meet you.

Love, Samsara