Shulou(Shulou.com)06/02 Report--

This article mainly introduces the use of linux myisamchk command to check and repair the MyISAM table, the article is very detailed, has a certain reference value, interested friends must read it!

Use the myisamchk command to check and repair the MyISAM table. Using commands without options, all tables are checked for errors.

Syntax format: myisamchk [parameters] [Table]

Common parameters:

Reference example

Check and repair the MyISAM table:

[root@linuxcool ~] # myisamchk / var/lib/mysql/mysql/db.MYI

Check and restore the T1 table:

[root@linuxcool ~] # myisamchk-iBfqr / var/lib/mysql/backup/t1

Set more memory for myisamchk to make it run faster:

[root@linuxcool ~] # myisamchk-- sort_buffer_size=16M-- key_buffer_size=16M-- read_buffer_size=1M-- write_buffer_size=1M is used to check and repair all the contents of the MyISAM table using the myisamchk command of linux. Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.