MySQL Tips
1) Restore DB a) mysql --user=root --password=root maheshsql_db < "C:\mydbbkp.sql" 2) MYSQL Get all table rows and size of each table in DB a) SELECT table_schema "Data Base Name" , SUM ( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB" FROM information_schema . TABLES GROUP BY table_schema ; b) SELECT TABLE_NAME , table_rows , data_length , index_length , round ((( data_length + index_length ) / 1024 / 1024 ), 2 ) "Size in MB" FROM information_schema . TABLES WHERE table_schema = "schema_name" ; c) SELECT SUM ( round ((( data_length + index_length ) / 1024 / 1024 ), 2 )) "Size in MB" FROM information_schema . TABLES WHERE table_schema = "schema_name" ; 3) Count no of tables in DB a) SELECT count(*) FROM information_schema.tables WHERE table_schema = &