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
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
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), according to Innodb Hot Backup
No worries about
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
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 kind
SuSE 8
Enterprise (64-bit). We are using ibbackup 2.0 beta (which is 64-bit for
the Opteron).
ibbackup (the Innodb backup utility) complains on the first file.
ibbackup: Re-reading page at offset 0 3272818688 in
/usr/local/mysql/var/ywdata1
this repeats a few hundred times
Then it dumps some
but i have not found the answer to the question:
how is it possible to do a backup of a innodb table?
i have read: try to use mysqldump.. but this does not work right
i have read: try to use mysqldump --single-transaction ... but i
dont
see any difference.. and doesnt work right
( first.. sorry for my english )
hello people..
i have read multiple websites and posts.. and this mail list archive
but i have not found the answer to the question:
how is it possible to do a backup of a innodb table?
i have read: try to use mysqldump.. but this does not work right
i have
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
i have read multiple websites and posts.. and this mail list archive
but i have not found the answer to the question:
how is it possible to do a backup of a innodb table?
i have read: try to use mysqldump.. but this does not work right
i
the answer to the question:
how is it possible to do a backup of a innodb table?
i have read: try to use mysqldump.. but this does not work right
i have read: try to use mysqldump --single-transaction ... but i dont
see any difference.. and doesnt work right too
i have read: use
Egorov wrote:
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
i have read multiple websites and posts.. and this mail list archive
but i have not found the answer to the question:
how is it possible to do a backup of a innodb table?
i have read: try to use mysqldump.. but this does not work right
i
:
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
i have read multiple websites and posts.. and this mail list archive
but i have not found the answer to the question:
how is it possible to do a backup of a innodb table?
i have read: try to use mysqldump.. but this does not work right
i
and posts.. and this mail list
archive
but i have not found the answer to the question:
how is it possible to do a backup of a innodb table?
i have read: try to use mysqldump.. but this does not work right
i have read: try to use mysqldump --single-transaction ... but i
dont
see any difference
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.
So restore == apply-log, but one works on any
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)
---
mydb2:/data # ./ibbackup --apply-log ./my2.cnf
InnoDB Hot Backup version
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
(specifically, restoring a backup
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,
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 that
with 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 PROTECTED]
Sent: Wednesday, April 21
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. Zawodny | Perl
Does anyone have any experience with Innodb Hot Backup Tool?
Thanks,
Ann
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:54 AM
Subject: Innodb Hot Backup Tool
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 219 days
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
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
(--apply-log works in any
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
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:
C versus object-oriented lanuguages like C
-
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]
Newsgroups
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 Backup + MySQL
embedded?
Jochem
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,
]
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]
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 21, 2004 2
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 into
).
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 Backup + MySQL
embedded
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
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
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
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
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
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?
Heikki,
Thank you greatly for answering my
, Heikki Tuuri wrote:
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,
Thanks for the quick
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,
Thanks for the quick response! It never ceases to amaze me
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) server-style application with
the embedded
on the challenge or run
screaming in the other direction and have a somewhat easier year.
Regards,
Chris
Heikki Tuuri wrote:
Chris,
- Original Message -
From: Chris Nolan [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, February 12, 2004 2:45 AM
Subject: InnoDB Hot Backup
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 database
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 being able
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 Backup supports the new tablespace
format being
Hey Guys,
I have just a couple of questions regarding the innodb database type
that I'd appreciate any advice with. I'm currently developing a custom
shopping cart / backend and, due to the nature of such a system, would
like to take advantage of transactions - so innodb seems the logical
Russ,
you can also use
mysqldump --single-transaction
to back up InnoDB type tables. The advantage of InnoDB Hot Backup over that
method is that InnoDB Hot Backup takes binary backups of the ibdata files.
Restoring a binary backup is much faster than a table dump.
Best regards,
Heikki Tuuri
!
bye and thanks.
Natale Babbo
--- Victoria Reznichenko
[EMAIL PROTECTED] ha scritto:
Natale,
Thursday, October 24, 2002, 10:57:00 AM, you wrote:
NB Anyone knows how to backup innodb tables in the
right
NB sql order?
NB ... i mean ... to allow restoring correctly
NB without foreign key
, October 24, 2002, 10:57:00 AM, you wrote:
NB Anyone knows how to backup innodb tables in the
right
NB sql order?
NB ... i mean ... to allow restoring correctly
NB without foreign key constraint violation (if in
the
NB backup file ddl code for the child table is
before ddl
NB code
scritto:
NB Natale,
Thursday, October 24, 2002, 10:57:00 AM, you
wrote:
NB Anyone knows how to backup innodb tables in
the
right
NB sql order?
NB ... i mean ... to allow restoring correctly
NB without foreign key constraint violation (if
in
the
NB backup file ddl code
Natale,
Friday, October 25, 2002, 1:44:19 PM, you wrote:
NB i tried it ... but nothing to do!
NB when mysql parse the foreign key in the create table i
NB get the error.
NB perhaps i'm wronging in restoring tables/db!
NB i use this method:
shell mysql -u user -ppassword dump file
NB is it
for me.
NB --- Victoria Reznichenko
NB [EMAIL PROTECTED] ha scritto:
NB Natale,
Thursday, October 24, 2002, 10:57:00 AM, you
wrote:
NB Anyone knows how to backup innodb tables in
the
right
NB sql order?
NB ... i mean ... to allow restoring correctly
NB without foreign key
Anyone knows how to backup innodb tables in the right
sql order?
... i mean ... to allow restoring correctly
without foreign key constraint violation (if in the
backup file ddl code for the child table is before ddl
code for the parent table i get an error).
Thanks in advance.
Natale Babbo
Natale,
Thursday, October 24, 2002, 10:57:00 AM, you wrote:
NB Anyone knows how to backup innodb tables in the right
NB sql order?
NB ... i mean ... to allow restoring correctly
NB without foreign key constraint violation (if in the
NB backup file ddl code for the child table is before ddl
NB
... can someone add InnoDB to the list of keywords?? SQL ... QUERY ...
Victoria Reznichenko wrote:
You can set up SET FOREIGN_KEY_CHECKS=0, in this case foreign key
constraints will not be checked. It's supported since 3.23.52 and
4.0.3
Out of curiousity, are the foreign key constraints
hi,
We can take backup for the subject above by two ways, One way is by
mysqldump ( Which I am using ..)
Now, I the second method
1. Shut down your MySQL database and make sure it shuts
down without errors.
2. Copy all your data files into a safe place.
58 matches
Mail list logo