whats the command to auto check repair optimize all tables from a single database if its possible Code: mysqlcheck -op -u user_name –all-databases it's for optimizing all databases for single one use such commands:
For optimizing:
Quote: mysqlcheck -Bo database_name For repairing:
Quote: mysqlcheck -Br database_name
For optimizing:
Quote: mysqlcheck -Bo database_name For repairing:
Quote: mysqlcheck -Br database_name