[help] how to check repaiur optimize all tables with ssh

[bachbell]

whats the command to auto check repair optimize all tables from a single database if its possible

bachbell Reviewed by bachbell on 2nd Apr 2012. [help] how to check repaiur optimize all tables with ssh whats the command to auto check repair optimize all tables from a single database if its possible Rating: 5

[JamesVaporH]

mysqlcheck -op -u user_name –all-databases

[CloudLIX]

it's for optimizing all databases for single one use such commands:

For optimizing:

mysqlcheck -Bo database_name

For repairing:

mysqlcheck -Br database_name