Category Archives: Database

MySQL: Cannot load from mysql.proc. The table is probably corrupted

Ok this one sounds pretty scary, but more than likely you just upgraded MySQL didn’t you? Did you run mysql_upgrade? Ok lets back up a bit. I just upgraded to MySQL 5.5.x using yum and a third party repo but … Continue reading

Posted in Database Administration, MySQL, Server Administration Tagged , , , , , ,

Case Sensitive Comparisons in MySQL Where Clause

How can I make MySQL treat my query as case sensitive? As with all good tools there’s more than one way to get the job done. Assuming you have access to change the structure of the table you have to … Continue reading

Posted in Code Snippets, Database, MySQL, SQL Tagged , ,

How do I Fix a Corrupt MySQL Table?

mysqldump Can’t open file: ‘tablename.MYD’. (errno: 145) This usually means the table has become corrupt. Most commonly this happens when the partition that contains your MySQL files is full, but I have had it happen at other times. Especially on … Continue reading

Posted in Database, MySQL, Server Administration Tagged , , , , ,

Database error fix… mysqldump: Couldn’t execute show create table view

Today I found that my automated MySQL backups have been choking for the last few days with “mysqldump: Couldn’t execute show create table view” because I recently added a view to one of the databases. Apparently the backup user needs … Continue reading

Posted in Code Snippets, Database, MySQL, Server Administration Tagged , , , , ,