Oh, and a followup question that I forgot to ask--what if the two
systems have different db schemas? Is it possible to do some sort of
mapping between the two?
On Fri, Mar 21, 2008 at 1:48 PM, Waynn Lue <[EMAIL PROTECTED]> wrote:
> I'm thinking of buying a license for this tool to do a migration
I'm thinking of buying a license for this tool to do a migration from
one server to another, but it's been hard for me to find good
documentation on it after searching for awhile last night. Is it
possible for me to migrate from a 32-bit to a 64-bit system across a
network? How long would perceiv
Hi all,
I'm getting the following error when attempting to run a hot backup of a
4.0.18 MySQL database using ibbackup:
ibbackup: We wait 10 seconds before starting copying the data files...
050330 14:26:33 ibbackup: Copying /mysqldata/mysqld1/ibdata1
ibbackup: Error: log scan was only able to
David,
- Alkuperäinen viesti -
Lähettäjä: "David Griffiths" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Tuesday, October 19, 2004 9:33 PM
Aihe: Re: MySQL Database Corruption (InnoDB),
bdata file of the production database.
InnoDB Hot Backup checks the page checksums when it copies the ibdata files.
Since CHECK TABLE fails, the corruption probably is in that table. You can
try to repair the corruption by dump + DROP + reimport of that table.
innodb_force_recovery cannot fix any ki
David,
I am sorry for a late reply.
The corruption clearly is in the ibdata file of the production database.
InnoDB Hot Backup checks the page checksums when it copies the ibdata files.
Since CHECK TABLE fails, the corruption probably is in that table. You can
try to repair the corruption by
I went to do some work on our database last night (dropping large
indexes, which can be time consuming). I checked to ensure that the
backup of that evening had run, but noticed that the size of the backup
was too small compared to previous days (I'm kicking myself for not
emailing the results
David,
- Original Message -
From: ""David Griffiths"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, May 14, 2004 8:05 PM
Subject: Re: InnodB Hot Backup Questions
> Sorry - haven't had a chance to respond till now.
>
>
tname or the
> license expiration date.
I'm running ibbackup on an unlicenced machine. The manual states,
"ibbackup --apply-log /home/pekka/.backup-my.cnf"
Here's the output with --apply-log (some sensitive info stripped)
---------
David,
- Original Message -
From: ""David Griffiths"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, May 13, 2004 7:50 AM
Subject: InnodB Hot Backup Questions
> I'm hoping someone on the list has some experience with the tool
&
I'm hoping someone on the list has some experience with the tool
(specifically, restoring a backup), as I'm stumped.
First, "--apply-log" seems to only work on the host that ibbackup is
lode-locked to. This doesn't make sense. Running the tool dumpes out some
text, and part of that text is,
"(--r
MyISAM tables (and possibly BDB, ISAM, etc). The InnoDB hot-backup
tool is the only way to get a consistent backup without shutting down your
database.
David.
- Original Message -
From: "McConnell, Ann M." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PR
Hello,
MAM> The good, bad, and the ugly of it? We're debating if we should use it on
MAM> our INNODB tables or use a script to do a hotbackup.
On a big database, restore a mysqldump file can take hours.
ibbackup is very fast. restore is near as fast as a file copy.
you can parameter the load tha
The good, bad, and the ugly of it? We're debating if we should use it on
our INNODB tables or use a script to do a hotbackup.
On Tue, Apr 20, 2004 at 01:54:37PM -0400, McConnell, Ann M. wrote:
> Does anyone have any experience with Innodb Hot Backup Tool?
Yes.
--
Jeremy D.
On Tue, Apr 20, 2004 at 01:54:37PM -0400, McConnell, Ann M. wrote:
> Does anyone have any experience with Innodb Hot Backup Tool?
Yes.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up
We're using an evaluation version right now - works great, though I've yet
to test a backup (and I need to do that soon).
David.
- Original Message -
From: "McConnell, Ann M." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 20, 2004 10:
Does anyone have any experience with Innodb Hot Backup Tool?
Thanks,
Ann
ibbackup. I
hope Linux kernels 2.6 will fix this issue, since the file i/o system is
modified in it, but I have not tested it.
Best regards,
Heikki
Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up
to use another file flush
method?
Thanks
-- START OUTPUT ---
[EMAIL PROTECTED] mysql-hotbak]# ibbackup --compress /etc/my.cnf
/var/mysql-hotbak/myhotbak.cnf
InnoDB Hot Backup version 2.0-beta5; Copyright 2003 Innobase Oy
License xx is granted to [EMAIL PROTECTED] x
(--ap
Egor,
If I write a script myself that backup .frm, .ibd and all log files, how good that
backup will be? Idea is not to shutdown the server though. Also I am using Innodb
tables, and mysqlhotcopy will not for Innodb. Innodb Hot backup tool works, but I
would prefer some free tool to do so
pt with a bad API written in C).
Complex tasks should be done from skilled programmers - thats all.
mfg
Klaus
-Ursprüngliche Nachricht-
Von: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Gesendet: Samstag, 21. Februar 2004 09:30
An: [EMAIL PROTECTED]
Betreff: C compared to C++/Java; Was: Re: Inno
>> I prefer TCL because on my opinion it is the best of both worlds
>> ( i never had a memleak except with a bad API written in C).
>Bad...written in C...was it a SCO library?
>> Complex tasks should be done from skilled programmers - thats all.
>Additionally, complex tasks should be decomposed int
mmers. :-)
>
> mfg
> Klaus
>
>
> -Ursprüngliche Nachricht-
> Von: Heikki Tuuri [mailto:[EMAIL PROTECTED]
> Gesendet: Samstag, 21. Februar 2004 09:30
> An: [EMAIL PROTECTED]
> Betreff: C compared to C++/Java; Was: Re: InnoDB Hot Backu
Heikki Tuuri wrote:
From: "Jochem van Dieten"
Sasha Pachev wrote:
In Java is it easy to write a program that wastes large amounts of
memory, which is worse than a leak. In C, you are full from the start,
and then you leak a drop at a time until you are empty. In Java , you
are empty from the start,
I written in C).
Complex tasks should be done from skilled programmers - thats all.
mfg
Klaus
-Ursprüngliche Nachricht-
Von: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Gesendet: Samstag, 21. Februar 2004 09:30
An: [EMAIL PROTECTED]
Betreff: C compared to C++/Java; Was: Re: InnoDB Hot B
-
Von: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Gesendet: Samstag, 21. Februar 2004 09:30
An: [EMAIL PROTECTED]
Betreff: C compared to C++/Java; Was: Re: InnoDB Hot Backup + MySQL
embedded?
Jochem,
- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED
Jochem,
- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 21, 2004 2:10 AM
Subject: Re: InnoDB Hot Backup + MySQL embedded?
> Sasha Pachev wrote:
> > Heikki Tuuri wrote:
>
Sasha Pachev wrote:
Jochem van Dieten wrote:
Sasha Pachev wrote:
Heikki Tuuri wrote:
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional
procedural
approaches and languages, like C, are the best for 'systems
programm
Sasha Pachev wrote:
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional procedural
approaches and languages, like C, are the best for 'systems
programming', by
which I mean implementing anything with complex data struct
Jochem van Dieten wrote:
Sasha Pachev wrote:
Heikki Tuuri wrote:
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional procedural
approaches and languages, like C, are the best for 'systems
programming', by
which I mean i
Sasha Pachev wrote:
Heikki Tuuri wrote:
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional procedural
approaches and languages, like C, are the best for 'systems programming', by
which I mean implementing anything with co
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional procedural
approaches and languages, like C, are the best for 'systems programming', by
which I mean implementing anything with complex data structures and lots of
paral
Chris,
- Alkuperäinen viesti -
Lähettäjä: "Chris Nolan" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Monday, February 16, 2004 1:56 PM
Aihe: Re: InnoDB Hot Backup + MySQL embedded?
On Sat, 2004-02-14 at 08:13, Heikki Tuuri wrote:
> Chris,
>
> - Original Message -
> From: "Chris Nolan" <[EMAIL PROTECTED]>
> To: "Heikki Tuuri" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Thursday, February
Chris,
- Original Message -
From: "Chris Nolan" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, February 12, 2004 2:26 PM
Subject: Re: InnoDB Hot Backup + MySQL embedded?
> Dear Heikki,
&g
M
Subject: InnoDB Hot Backup + MySQL embedded?
Hi all,
I'm looking at developing an (open source) server-style application with
the embedded MySQL library to be employed as the primary data store.
Has anyone attempted to use InnoDB Hot Backup for such a beast? I ask as
I do not know whe
Chris,
- Original Message -
From: "Chris Nolan" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, February 12, 2004 2:45 AM
Subject: InnoDB Hot Backup + MySQL embedded?
> Hi all,
>
> I'm looking at developing an (open source) serve
Hi all,
I'm looking at developing an (open source) server-style application with
the embedded MySQL library to be employed as the primary data store.
Has anyone attempted to use InnoDB Hot Backup for such a beast? I ask as
I do not know whether communication between ibbackup and the dat
Chris,
- Original Message -
From: "Chris Elsworth" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 07, 2004 7:25 PM
Subject: InnoDB Hot Backup & new tablespace format
> Hello,
>
> Does anyone know if InnoDB Hot Backu
Hello,
Does anyone know if InnoDB Hot Backup supports the new tablespace
format being introduced in the latest versions of InnoDB?
I'm quite tempted to switch from MyISAM to InnoDB using the new
tablespace format, but I'm put off by how inflexible InnoDB files seem
to be. I like bei
40 matches
Mail list logo