Sorry. Obviously didn't see this...
-----Phil <[EMAIL PROTECTED]> wrote: ----- To: Dan Greene <[EMAIL PROTECTED]> From: Phil <[EMAIL PROTECTED]> Date: 02/06/2004 09:36AM cc: gerald_clark <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Subject: RE: How to determine when a MySQL database was last modified? Thanks. I'm using InnoDB tables (for transactions) and there's no sign of any .MYD files for them. I'm starting to think that maybe this information isn't available :( Anyone any other ideas? On Fri, 2004-02-06 at 14:17, Dan Greene wrote: > 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
