SQL database stores the information of your site which can be used to take backup your website. Changes made to the website like posting articles, comments etc update the SQL database. With time errors may results in the database. There are two easy to repair and optimize the SQL database.
- Using ssh command: mysqlcheck -auto-repair -u`whoami` -p -A -o
- Use cPanel: Go to PHPMyAdmin through databases section. Select the database you want to repair or optimize. Select all tables which include your posts, categories, comments, links, users, etc by using ‘Check All’ option at the bottom of the tables. Choose repair option from right side of the check all option. For optimization, select the optimize option in the menu after repeating above steps.
Source: Article first published in Blogger’s Magazine.