List:General Discussion« Previous MessageNext Message »
From:Heikki Tuuri Date:May 19 2004 7:08am
Subject:Re: InnodB Hot Backup Questions
View as plain text  
David,

----- Original Message ----- 
From: ""David Griffiths"" <dgriffiths@stripped>
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 computer, and the
> other
> > > only works on the computer that it's node locked to.
>
> > --apply-log works also in any computer regardless of the hostname or the
> > license expiration date.
>
>
> I'm running ibbackup on an unlicenced machine. The manual states,
>
> "ibbackup --apply-log /home/pekka/.backup-my.cnf"

the manual is already updated for ibbackup-2.0, while there is
no --apply-log option at all in ibbackup-1.40 :(. In 1.40 you must
use --restore.

Please use

./ibbackup --help

to look at the available options in 1.40.

ibbackup-2.0.0 has now been declared stable on Linux, and on Linux we are
only shipping 2.0.0 from now on.

> Here's the output with --apply-log (some sensitive info stripped)
>
> -------------------------------------------------------
> mydb2:/data # ./ibbackup --apply-log ./my2.cnf
> InnoDB Hot Backup version 1.40; Copyright 2003 Innobase Oy
> License xxx is granted to
> (--restore works in any computer regardless of the hostname)
> Licensed for use in a computer whose hostname is 'hrdb1'
> Expires 2005-6-1 (year-month-day) at 00:00
> See http://www.innodb.com for further information
> Type ibbackup --license for detailed license terms, --help for help
>
> --- Error: the hostname of this computer is 'mydb2'.

I guess ibbackup interprets that your first my.cnf file is called
'--apply-log', it does not understand it is an option (of 2.0)! Then it
refuses to run because the hostname of the computer does not match.

...
> David.

Best regards,

Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php

Order MySQL technical support from https://order.mysql.com/

Thread
InnoDB replication to MYISAMShayne Paddock12 May
  • Re: InnoDB replication to MYISAMJeremy Zawodny12 May
  • InnodB Hot Backup QuestionsDavid Griffiths13 May
Re: InnodB Hot Backup QuestionsHeikki Tuuri13 May
Re: InnodB Hot Backup QuestionsDavid Griffiths14 May
Re: InnodB Hot Backup QuestionsHeikki Tuuri19 May