mysql_qtd_linha.php
<?php
$con = mysqli_connect("127.0.0.1", "root", "senha");
$sql = "SELECT TABLE_SCHEMA, TABLE_NAME FROM information_schema.tables WHERE TABLE_TYPE LIKE 'VIEW'";
$result = mysqli_query($con,$sql);
system("echo '' > /tmp/mysql_qtd_registro.log");
while ($row=mysqli_fetch_array($result,MYSQLI_ASSOC)) {
$sql = "select count(*) quantidade from ".$row['TABLE_SCHEMA'].".".$row['TABLE_NAME']." limit 1";
echo $sql."\n";
$result2 = mysqli_query($con,$sql);
if(!$result2){
$msgErro[] = mysqli_error($con);
}else{
$row2 = mysqli_fetch_assoc($result2);
system("echo '".$row['TABLE_SCHEMA'].".".$row['TABLE_NAME']." -> ".$row2['quantidade']." linhas' >> /tmp/mysql_qtd_registro.log");
}
}
system('clear');
print_r($msgErro);
mysqli_free_result($result);
mysqli_close($con);