Feb
28
2011
mysqldump: Got error: 145: Table ‘./wordpress/bot_prli_clicks’ is marked as crashed and should be repaired when using LOCK TABLES
Posted by alex in ErrorsEarlier 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.
Tags: .frm, .MYD, .MYI, /var/lib/mysql, 145, 5.0, 5.1, CentOS, crashed, data records, database, error, fixing index, Linux, LOCK TABLES, myisamchk, mysql, mysqldump, outside data file, repaired








Entries (RSS)