We’re rewarding the question askers & reputations are being recalculated! Read more.

New answers tagged


I could not execute queries because of the "too many columns" error since it brought many columns, I changed the variable internal_tmp_disk_storage_engine to MyISAM and it was fixed.


Identify all corrupted tables using myisamchk # myisamchk /var/lib/mysql/bugs/*.MYI >> /tmp/myisamchk_log.txt myisamchk: error: Wrong bytesec: 0-0-0 at linkstart: 18361936 MyISAM-table 'attach_data.MYI' is corrupted Fix it using switch "-r" or "-o" myisamchk: warning: 1 client is using or hasn't closed the table properly MyISAM-table 'groups.MYI' is ...

Top 50 recent answers are included