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]
