Re: Re: Copy 70GB ibdata, etc. and server won't start now (Action Required)

2009-07-15 Thread Todd Lyons
> Status: 4.7.0 > > > > ------ Forwarded message ------ > From: Todd Lyons > To: > Date: Wed, 15 Jul 2009 05:28:46 -0700 > Subject: Re: Copy 70GB ibdata, etc. and server won't start now > > -- Regards... Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Copy 70GB ibdata, etc. and server won't start now

2009-07-15 Thread Todd Lyons
On Tue, Jul 14, 2009 at 2:14 AM, Marcus Bointon wrote: > You should take a look at Percona's xtrabackup utility to do this. It takes > a clean snapshot of an innodb database that can be restored on a target > machine in a few minutes, though it does crash recovery at backup time which > can take a

Re: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Carlos Proal
Yep, you dont need to recover the database because: 1) You did a clean shutdown 2) You dont need (as i believe) an integral copy of your database, because its for a demo, anyway the data is 1 month older, so if you miss some records that "probably" will be missing on the log those are not relev

RE: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Daevid Vincent
> -Original Message- > From: Carlos Proal [mailto:carlos.pr...@gmail.com] > Sent: Tuesday, July 14, 2009 5:13 PM > > > > Another thing you can do is simply erase the innodb logs. > If the dbms > > really was shutdown properly then the logs are useful, > > they will be recreated again and

Re: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Carlos Proal
but the dates will change as I muck with the data on it. From: Gary Smith [mailto:g...@primeexalia.com] Sent: Tuesday, July 14, 2009 2:11 PM To: Johnny Withers; Daevid Vincent Cc: mysql@lists.mysql.com Subject: RE: Copy 70GB ibdata, etc. and server

Re: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Carlos Proal
Gary Smith [mailto:g...@primeexalia.com] Sent: Tuesday, July 14, 2009 2:11 PM To: Johnny Withers; Daevid Vincent Cc: mysql@lists.mysql.com Subject: RE: Copy 70GB ibdata, etc. and server won't start now Johnny, I'm less worried about the mont

RE: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Daevid Vincent
From: Gary Smith [mailto:g...@primeexalia.com] Sent: Tuesday, July 14, 2009 2:11 PM To: Johnny Withers; Daevid Vincent Cc: mysql@lists.mysql.com Subject: RE: Copy 70GB ibdata, etc. and server won't start now

RE: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Daevid Vincent
_ 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 betwee

RE: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Gary Smith
imeexalia.com<mailto:g...@primeexalia.com>] > Sent: Monday, July 13, 2009 8:54 PM > To: Daevid Vincent; mysql@lists.mysql.com<mailto:mysql@lists.mysql.com> > Subject: RE: Copy 70GB ibdata, etc. and server won't start now > > > InnoDB: Your database may be corrupt or you may ha

RE: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Gary Smith
. I think as others have mentioned, the startup recovery flags might be your best bet. From: Daevid Vincent [dae...@daevid.com] Sent: Tuesday, July 14, 2009 12:23 PM To: mysql@lists.mysql.com Cc: Gary Smith Subject: RE: Copy 70GB ibdata, etc. and serv

Re: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Johnny Withers
> To: Daevid Vincent; mysql@lists.mysql.com > > Subject: RE: Copy 70GB ibdata, etc. and server won't start now > > > > > InnoDB: Your database may be corrupt or you may have copied > > the InnoDB > > > InnoDB: tablespace but not the InnoDB log files. See >

RE: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Daevid Vincent
> -Original Message- > From: Gary Smith [mailto:g...@primeexalia.com] > Sent: Monday, July 13, 2009 8:54 PM > To: Daevid Vincent; mysql@lists.mysql.com > Subject: RE: Copy 70GB ibdata, etc. and server won't start now > > > InnoDB: Your database may be c

Re: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Marcus Bointon
You should take a look at Percona's xtrabackup utility to do this. It takes a clean snapshot of an innodb database that can be restored on a target machine in a few minutes, though it does crash recovery at backup time which can take a while. Marcus -- MySQL General Mailing List For list a

Re: Copy 70GB ibdata, etc. and server won't start now

2009-07-13 Thread Carlos Proal
On 7/13/2009 9:19 PM, Daevid Vincent wrote: Both systems are UTC time so I don't get the issue with the sequence number is in the future business either. If I ever do get mysqld to start using the "innodb_force_recovery = 4" line, then as you know, I can't alter/update/insert. And it seems any a

RE: Copy 70GB ibdata, etc. and server won't start now

2009-07-13 Thread Gary Smith
> InnoDB: Your database may be corrupt or you may have copied the InnoDB > InnoDB: tablespace but not the InnoDB log files. See > InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html > InnoDB: for more information. > InnoDB: Error: trying to access page number 2144600306 in space 0,

Copy 70GB ibdata, etc. and server won't start now

2009-07-13 Thread Daevid Vincent
I have a 70GB database that I need to put on another box I'm building (Ubuntu 9.04 w/ext4, 1TB drive). I copy these files from the existing database (stopped it first of course) via USB HD. Doing a mysql dump/restore isn't really realistic as it gets exponentially slower and can take from 3-5 days