「实战笔记」mysql表修复实战

#./mysqlcheck -u root -p table --auto-repair

mysql: UnkNown OS character set 'GB18030'. 

mysql: Switching to the default character set 'latin1'. 

MySQL ERROR 1045 (28000): access denied for user 'root'@'localhost' (using password: NO)

#vi /etc/profile 

export LC_ALL="C"

export LANG="zh_CN.UTF-8"

#source /etc/profile 

#service mysqld stop

#service mysqld start --skip-grant-tables

#mysql -u root mysql

mysql>UPDATE user SET Password=PASSWORD('123456') where USER='root';

mysql> FLUSH PRIVILEGES;

#service mysqld restart

./mysqlcheck -u root -p table --auto-repair

……

table.zsshopconfig                     OK

table.zsstore                          OK

table.zwinstance                       OK

table.zwstep                           OK

table.zwworkflow                       OK

Repairing tables

table.??

Error    : Table 'table.??' doesn't exist

status   : Operation failed

table.ldtaskrunlog

warning  : Number of rows changed from 7 to 8

status   : OK

table.sdcacheerroermail

warning  : Number of rows changed from 629 to 630

status   : OK

[root@test bin]