CODEWITHSUNDEEP
mysqlrepair
selva
selva

Reputation: 18

Database query failed. Error received from database was #144:

Database query failed. Error received from database was #144: Table 'dbname.mantis_bug_file_table' is marked as crashed and last (automatic?) repair failed for the query: SELECT bug_id, COUNT(bug_id) AS attachments
FROM mantis_bug_file_table
GROUP BY bug_id.

How to avoid above issue. Many times I got this error after repair table. If I repair table after loading the page it's says "#2013 - Lost connection to MySQL server during query".

Thanks.

Upvotes: 0

Views: 686

Answers (1)

PSR
PSR

Reputation: 40318

Stop MySQL process first.Go to your data folder and try running myisamchk -r <table_name>. If it is not work then try with myisamchk -r -v -f <table_name>.

Upvotes: 1

Related Questions