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]
