I'm not 100% sure on this, but what about the .myd file timestamp? > -----Original Message----- > From: gerald_clark [mailto:[EMAIL PROTECTED] > Sent: Friday, February 06, 2004 9:09 AM > To: Phil > Cc: [EMAIL PROTECTED] > Subject: Re: How to determine when a MySQL database was last modified? > > > 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]