use xtrabackup"s innobackupex tool to back up the mysql database, some of which are myisam engines. After another machine is restored, when querying the table, prompt table "xxx" is marked as crashed and should be repaired, to use the repair command to repair it can return to normal, but to be executed table by table, what is the solution?
repair
using mysqlcheck command
Common parameters of mysqlcheck:
-a --all-databases
-r --repair
-c --check
-a --analyze
-o --optimize
-q --quik
-F --fast
A, all-databases
-a, analyze
-o, optimize
-r, repair
-c, check
auto-repair
-B, databases e.g.:
-sharp
mysqlcheck -u root -p -A -c
-sharp
mysqlcheck -u root -p -A -r
-sharp
mysqlcheck -u root -p -r database_namePrevious: The modal module of antd is used in react. How to get a dom element in modal if you want to get it?
Next: The front end of the Transfer shuttle box problem in antd