_____
From: Johnny Withers [mailto:joh...@pixelated.net]
Sent: Tuesday, July 14, 2009 1:41 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com; 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