Mysql’de Tüm Veritabanları ve Tablo Sayıları

here is How to list all databases and their table count on Mysql Server.

mysqlcheck -u root -p --auto-repair --check --all-databases
Repair all Mysql Table in all schemas

 

select TABLE_schema ,count(table_name) from information_schema.`TABLES` group by TABLE_schema
List Schemas and Tables

 

select concat('repair table ', table_name, ';') from information_schema.tables 
where table_schema='mydatabase';
Creating repair all tables script of selected database
CentiSOFT