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]
