This db had LOTS of tables... That's why I'm simply trying to get the total.
Is there a way to only get one column of this. then I can do something like select SUM(show table status (rows));
[EMAIL PROTECTED] wrote:
try: SHOW TABLE STATUS
Shawn Green Database Administrator Unimin Corporation - Spruce Pine
"Michael J. Pawlowsky" <[EMAIL PROTECTED]> wrote on 10/14/2004 06:54:16 AM:
> Does anyone know of a quick way to get the number of rows in a database
> from the command prompt.
>
> I run a cron job that does a mysql dump nightly from a prod server piped
> to a standy server.
> It's a 2 line shell script including outputting the date at time.
>
> After the dump, I would like to output the number of rows in the prod
> database and the newly updated standby database to make sure these
> match. The output is e-mailed to me, so in the morning I could simply
> see if they match and be assured that the dump went well.
>
> Thanks,
> Mike
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
