Doesn't seem to change the mtime on table files. It appears that for
InnoDB tables these files are only updated when the definition of a
table is changed. The content of the all InnoDB tables is kept in one or
two massive files directly under the 'data' directory!



On Fri, 2004-02-06 at 18:13, Brian Reichert wrote:
> On Fri, Feb 06, 2004 at 09:17:32AM -0500, Dan Greene wrote:
> > I'm not 100% sure on this, but what about the .myd file timestamp?
> 
> Well, it depends on which table type, obvously.  There are several
> files for each database, see what the mtime is on each of them, to
> determine what's a live file.
> 
> If you're using rsync for backups, I wouldn't worry; it's good at
> moving partial files around.
> 
> -- 
> Brian Reichert                                <[EMAIL PROTECTED]>
> 37 Crystal Ave. #303                  Daytime number: (603) 434-6842
> Derry NH 03038-1713 USA                       BSD admin/developer at large    


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to