mysqldump failed. locked tables

Published by

Posted on April 25, 2008

Got error: 1016: Can’t open file: ‘threadviews.MYI’. (errno: 145) when using LOCK TABLES

run the repair command and then try the dump again

mysqlcheck -r -u mysqlusername -p databasename