php3-list | 2000051

Re: [PHP3] Display when database was last updated From: Richard Lynch (richard <email protected>)
Date: 05/16/00

In article <00051516263000.00889 <email protected>>,
tyler.longren <email protected> (Tyler Longren) wrote:

> How can I get the date when a MySQL database was last updated? This can't be
> too hard, but I don't know how to do it. Thanks!

You many any change at all to the database?...

I'm guessing you could dig around in wherever MySQl stores its files and
look at the mod_time of the files for that database...

Or, if you have records in there that are being marked as "changed" you
could do:

select max(changedate) from blah; 

-- 
Richard Lynch                | If this was worth $$$ to you, buy a CD
US Customer Support Director | from one of the artists listed here:
Zend Technologies USA        | http://www.L-I-E.com/artists.htm
http://www.zend.com          | (this has nothing to do with Zend, duh!)

-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin <email protected>