mysql database corruption.

Hosting jappler.com

What got me up early Saturday and then up at 1am on Sunday? Server hardware failure…which led to some database corruption. I have never had to deal with database corruption, so I did not even know my problem was database corruption until after calling the helpful tech guys at Liquid Web. (I am not one to usually call tech support, but at 136am on a Sunday…I did not feel like spending time at mysql.com or google.com.)

I first noticed something on Saturday morning, but after restoring a database table from a backup, everything was golden. I told myself…it had to have been from some user error. Monday morning, after my Nagios server paged me, I noticed that jappler.com had several mysql fetch_row () errors after the server came back up. I decided that this problem was not user error and something else was going on. As soon as I told the tech guy the error that I was seeing onjappler.com and other web sites I manage, he asked me if I had tried “repairing” the databases. I had not even thought about it (especially so early in the morning). Once he “repaired the databases”, everything was perfect.

This was a stressful lesson to learn, but I am always happy to learn new things. The lesson I learned was about database corruption. (All my tables are MyISAM)

[tags]MySQL, database corruption, CPANEL, MyISAM[/tags]

2 thoughts on “mysql database corruption.”

Leave a Reply

Your email address will not be published.
*
*

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Software

Nagios 2.0 Stable

Just after I got Nagios 1.2 up and running nicely (which it saved me the last few days with the server hardware failure) I get an email letting me know Nagios 2.0 stable has been released. I have been looking forward to Nagios 2.0 for awhile now, mostly because they simplified the conf files tremendously. […]

Web Development WordPress

wordpress 2.0.1/tasks 1.6 update.

I decided to update WordPress to 2.0.1 and only have found an issue with one plugin (PageNavi). A huge thanks to the WordPress development team who have once again, released an easy-to-update release. As always, make sure you backup your WordPress install before upgrading. I also updated my Tasks Pro install yesterday to 1.6 and […]