Technology Errors

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

Errors2 Comments

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

Canfield Imaging Systems: Backup VISIA SQL Database And Upgrade VISIA 4.2 To VISIA 5.0

InsightsLeave a comment

One of my clients uses VISIA medical imaging software from Canfield Imaging Systems for various forms of medical research projects. They have had the VISIA software and imaging station for a year or more and recently needed to upgrade the software to take advantage of some new features available in VISIA 5.0. The client’s VISIA installation was at VISIA 4.2 so it required a major update to get to VISIA version 5.0. Upgrading the software is fairly easy but it is important to make sure you have current backups before the upgrade begins. Follow the directions below to first backup your the Microsoft SQL Server, backup the VISIA files, and then proceed with upgrading VISIA 4.2 to VISIA 5.0.