MySQL: Check, Optimize and Repair Tables using Mysqlcheck

Recently, our MySQL MyISAM table corrupted due to certain reason. Using mysqlcheck command, we can optimize, repair and analyse the tables. (For MyISAM Engine) First, check a specific table: You can execute this command by giving DatabaseName and Table name. [crayon-6a34fccd15df6030193238/] Check all the tables of a Database: Using below command, you can also check […]

January 12, 2016 MySQL