Don't know if it can be done in the database without lots of legwork.
You can just use the filesystem to do it though. ls -la within the database directories. It'd probably be a lot easier to use perl or php file functions, then you'd be able to do all your calculations in epoch. P -----Phil <[EMAIL PROTECTED]> wrote: ----- To: gerald_clark <[EMAIL PROTECTED]> From: Phil <[EMAIL PROTECTED]> Date: 02/06/2004 09:27AM 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]