List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:July 14 2009 8:58pm
Subject:RE: Copy 70GB ibdata, etc. and server won't start now
View as plain text  
 


  _____  

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


Thread
Copy 70GB ibdata, etc. and server won't start nowDaevid Vincent14 Jul
  • RE: Copy 70GB ibdata, etc. and server won't start nowGary Smith14 Jul
    • RE: Copy 70GB ibdata, etc. and server won't start nowDaevid Vincent14 Jul
      • Re: Copy 70GB ibdata, etc. and server won't start nowJohnny Withers14 Jul
        • RE: Copy 70GB ibdata, etc. and server won't start nowGary Smith14 Jul
          • RE: Copy 70GB ibdata, etc. and server won't start nowDaevid Vincent15 Jul
            • Re: Copy 70GB ibdata, etc. and server won't start nowCarlos Proal15 Jul
              • Re: Copy 70GB ibdata, etc. and server won't start nowCarlos Proal15 Jul
                • RE: Copy 70GB ibdata, etc. and server won't start nowDaevid Vincent15 Jul
                  • Re: Copy 70GB ibdata, etc. and server won't start nowCarlos Proal15 Jul
        • RE: Copy 70GB ibdata, etc. and server won't start nowDaevid Vincent14 Jul
      • RE: Copy 70GB ibdata, etc. and server won't start nowGary Smith14 Jul
  • Re: Copy 70GB ibdata, etc. and server won't start nowCarlos Proal14 Jul
  • Re: Copy 70GB ibdata, etc. and server won't start nowMarcus Bointon14 Jul
    • Re: Copy 70GB ibdata, etc. and server won't start nowTodd Lyons15 Jul