mysql cli dump and repair commands

some usefull mysql commands for cli

 

Repair

mysqlcheck –user=root –password=*** –auto-repair –check –optimize –all-databases

 

Myisam

myisamchk –force

 

Dump

mysqldump –opt –user=root –password=*** –all-databases –skip-lock-tables –force > dump.sql