Record counts from all tables in MySQL database

mysql> SELECT SUM(TABLE_ROWS) 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_SCHEMA = 'DB_NAME';

Replace DB_NAME with real database name