If offline tools works for you try './mysqlshow.exe -vi <db_name>'. This provides useful information such as 'Create Time' 'Update Time' and 'Check Time'.
Gowtham. --- Phil <[EMAIL PROTECTED]> wrote: > Nice try... but 'show table status' just displays > NULL for Update_time - > maybe because they're InnoDB tables. Besides, I > didn't really want to > have to squirrel around all the tables to see if the > DB itself has been > changed. > > Since what I want to do doesn't seem possible I'll > carry on as usual... > backing everything up :( Also, I'll suggest it as an > enhancement. > Thanks. > > > On Fri, 2004-02-06 at 14:28, Schwartz, Evelyn wrote: > > You can try the 'show table status' from mysql. > There is an update_time that lists the last modified > date for the table. > > > > I also found out that these types of commands work > with perl DBD::mysql. You can treat the command > like a normal sql statement and the results are > returned like any other sql. Pretty cool. > > > > IMHO I wouldn't bother with this. Just take the > backup. As long as you only keep the most recent > backup online I don't see the harm. Why do the > extra work and risk not having backups? > > > > Evelyn > > > > -----Original Message----- > > From: Phil [mailto:[EMAIL PROTECTED] > > Sent: Fri 2/6/2004 9:27 AM > > To: gerald_clark > > Cc: [EMAIL PROTECTED] > > Subject: Re: How to determine when a MySQL > database was last modified? > > > > > > > > Thanks. But I would have thought that such > information would have been > > kept automatically somewhere by the server, and > it's just a case of how > > to get at it. I have quite a few tables in each > database so I don't > > really want to have to maintain a timestamp on > each update, and then go > > around all of them at backup time :( > > > > Anyone got any other ideas? > > > > > > On Fri, 2004-02-06 at 14:09, gerald_clark wrote: > > > Add a timestamp field to each table. > > > > > > Phil wrote: > > > > > > >Hi, > > > > > > > >I have many smallish, discrete MySQL > databases, each of which I would > > > >like to backup individually (mysqldump seems > fine for this). However, > > > >there's no point re-backing up a database that > has not changed since the > > > >last time it was backed up. So how can I tell > if when a MySQL database > > > >was last modified, so that I can decide > whether to run mysqldump on it > > > >again or not? Any help with this would be much > appreciated. > > > > > > > >Thanks, > > > >Phil > > > > > > > > > > > > > > > > > > > > > > > > > -- > > 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] > __________________________________ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online. http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]