List:General Discussion« Previous MessageNext Message »
From:Andrew Braithwaite Date:May 5 2009 3:58pm
Subject:RE: Creation date
View as plain text  
The create date in show table status is metadata held in the table
itself wheras the create data on the .frm file is when that file was
created - i.e. if you copy the data files (without preserving
attributes) it will have a new creation date on the filesystem but the
metadata of the table will not change.

Andrew

-----Original Message-----
From: Jim Lyons [mailto:jlyons4435@stripped] 
Sent: 05 May 2009 16:38
To: Jerry Schwartz
Cc: mysql@stripped
Subject: Re: Creation date

I would have said to look at the creation date of the .frn file, but
there
is also a field called "create date" in the "show table status" command
and
the 2 dates often differ.  Anyone know why they do?

On Tue, May 5, 2009 at 9:28 AM, Jerry Schwartz
<jschwartz@stripped>wrote:

> At the risk of getting spanked for not finding this in the
documentation,
> I'm asking a simple question:
>
>
>
> Can I tell when a table was created?
>
>
>
> Regards,
>
>
>
> Jerry Schwartz
>
> The Infoshop by Global Information Incorporated
>
> 195 Farmington Ave.
>
> Farmington, CT 06032
>
>
>
> 860.674.8796 / FAX: 860.674.8341
>
>
>
>  <http://www.the-infoshop.com> www.the-infoshop.com
>
>
>
>


-- 
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
Thread
Creation dateJerry Schwartz5 May
  • Re: Creation dateSteve Edberg5 May
    • RE: Creation dateJerry Schwartz5 May
  • RE: Creation dateMartin Gainty5 May
  • Re: Creation dateJim Lyons5 May
    • RE: Creation dateAndrew Braithwaite5 May