I'm want ALL the rows from the WHOLE DATABASE not just one table.
I could do a show tables and then loop through each one and perform the select count and add it up.
But I'm hoping to find a better way.
As for the script, simply read the mysqldump man page. It is in the examples near the bottom.
In this case I needed to tweak it a bit by adding some quotes (-Q) and extenderd inserts etc. Otherwise I was gettting errors.
But I ran the stock example on the man page for a couple of years now on 2 other databases.
Mike
Sujay Koduri wrote:
hi..
you can use...
select */count(1) /*from table_name; (it will traverse only column 1)
as count(*) will go through all the columns, it will take much time compared to this which generally will take less time.
by the way, can you send the shell script which you are using, it might be of some use to me.
Thanks
sujay
-----Original Message----- From: Michael J. Pawlowsky [mailto:[EMAIL PROTECTED] Sent: Thursday, October 14, 2004 4:24 PM To: [EMAIL PROTECTED] Subject: Number of Rows in DB.
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]