> 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
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
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
> -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
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
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
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
_
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
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
.
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
> 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
>
> -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
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
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
> 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,
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
16 matches
Mail list logo