Technology Errors

mysqldump: Got error: 145: Table ‘./wordpress/bot_prli_clicks’ is marked as crashed and should be repaired when using LOCK TABLES

Earlier I was in the process of upgrading MySQL on a CentOS Linux server and ran into an error when I attempted to backup all of the MySQL databases. When issuing the mysqldump command I received an error 145 noting that one of the mysql database tables was marked as crashed and needed to be repaired. Below I have noted the error in more detail as well as how to repair any tables that are marked as crashed.

Technology Insights

Upgrade PHP Version 5.1 to PHP Version 5.2 With Yum On a CentOS Server Running ISPConfig

I ran into some errors with my PHP modules on a CentOS server running ISPConfig to host web sites. I decided instead of in depth troubleshooting that it might be easier to go ahead and upgrade PHP since by default the yum package manager will limit you to PHP version 5.1 yet I knew that PHP version 5.2 had been out for a long time. What I needed to do was locate a yum repository that would allow me to upgrade PHP to version 5.2 using yum. The catch was to make sure that every necessary PHP module had an updated package available via the new yum repository. Below I describe upgrading PHP version 5.1 to PHP version 5.2 on CentOS running ISPConfig.