Thanks for checking this out. However, with InnoDB tables you only get
the .frm files under a database directory and these are only modified
when you change the definition of a table. The data itself is kept in a
big binary file(s) one directory up, whose modification time cannot be
used to deduce
On Fri, Feb 06, 2004 at 08:18:10PM +, Phil wrote:
> 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
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, Br
On 06-Feb-2004 Phil wrote:
> 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 e
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 y
[EMAIL PROTECTED]
> Sent: Friday, February 06, 2004 9:18 AM
> To: Gowtham Jayaram
> Cc: Phil; Schwartz, Evelyn; [EMAIL PROTECTED]
> Subject: Re: How to determine when a MySQL database was last modified?
>
>
> mysqlshow gives the same results as SHOW TABLE STATUS, which,
>
wtham Jayaram
Cc: Phil; Schwartz, Evelyn; [EMAIL PROTECTED]
Subject: Re: How to determine when a MySQL database was last modified?
mysqlshow gives the same results as SHOW TABLE STATUS, which,
unfortunately, doesn't seem to give created/updated dates for InnoDB
tables.
Michael
Gowtham Jayara
ool.
IMHO I wouldn't bother with this. Just take the
backup. As long as you only keep the most recent
backup online I don't see the harm. Why do the
extra work and risk not having backups?
Evelyn
-Original Message-
From: Phil [mailto:[EMAIL PROTECTED]
Sent: Fri 2/6/2004 9:
wouldn't bother with this. Just take the
> backup. As long as you only keep the most recent
> backup online I don't see the harm. Why do the
> extra work and risk not having backups?
> >
> > Evelyn
> >
> > -----Original Messa
As long as you only keep
> the most recent backup online I don't see the harm. Why do the extra work and risk
> not having backups?
>
> Evelyn
>
> -Original Message-
> From: Phil [mailto:[EMAIL PROTECTED]
> Sent: Fri 2/6/2004 9:27 AM
>
; 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
h.
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
Phil [mailto:[EMAIL PROTECTED]
Sent: Fri 2/6/2004 9:27 AM
To: gerald_clark
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
his, 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 data
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 th
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 dat
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
17 matches
Mail list logo
