From: Daevid Vincent
Date: July 14 2009 8:58pm
Subject: RE: Copy 70GB ibdata, etc. and server won't start now
List-Archive: http://lists.mysql.com/mysql/218185
Message-Id: <463BBEA71104462D918546C739B7277D@mascorp.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0053_01CA048B.1ED21490"

------=_NextPart_000_0053_01CA048B.1ED21490
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

 


  _____  

From: Johnny Withers [mailto:johnny@stripped] 
Sent: Tuesday, July 14, 2009 1:41 PM
To: Daevid Vincent
Cc: mysql@stripped; Gary Smith
Subject: Re: Copy 70GB ibdata, etc. and server won't start now


Why do the dates on the log files differ by almost a month between Old and
New? 
 
Because the 70GB snapshot was copied a month ago when we swapped out some
hardware and drives and such. So the data on my "new" box will be a month
old, but that's fine. It's for a live demo and doesn't need to be current --
just have stuff to play with. 
 
And everytime you muck with the database, it updates the stamp, so these
dates are misleading. 

+------+
| Old: |
+------+
mysql  Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline
5.2

drwx------ 2 mysql mysql       12288 2009-06-26 21:33 agis_core
-rw-r--r-- 1 mysql mysql           0 2008-11-24 23:34 debian-5.0.flag
-rw-rw---- 1 mysql mysql 72387395584 2009-07-14 19:18 ibdata1
-rw-rw---- 1 mysql mysql     5242880 2009-07-14 19:18 ib_logfile0
-rw-rw---- 1 mysql mysql     5242880 2009-07-14 18:30 ib_logfile1


drwxr-xr-x 2 mysql mysql        4096 2008-11-24 23:34 mysql



+------+
| New: |
+------+
mysql  Ver 14.12 Distrib 5.0.75, for debian-linux-gnu (i486) using readline
5.2

drwx------ 2 mysql mysql       12288 2009-07-14 00:36 agis_core
-rw-r--r-- 1 mysql mysql           0 2008-11-24 23:34 debian-5.0.flag

-rw-rw---- 1 mysql mysql 70038585344 2009-06-17 04:09 ibdata1

-rw-rw---- 1 mysql mysql     5242880 2009-07-14 01:43 ib_logfile0

-rw-rw---- 1 mysql mysql     5242880 2009-06-17 03:22 ib_logfile1

drwxr-xr-x 2 mysql mysql        4096 2009-07-14 00:36 mysql


------=_NextPart_000_0053_01CA048B.1ED21490--