[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Innodb  Hot backup
From:       "Ansari, Raza \(GEI, GEFA\)" <Raza.Ansari () ge ! com>
Date:       2004-02-27 22:56:02
Message-ID: C38715234A409B49B36BC4393B277AF801298B50 () CINMLVEM08 ! e2k ! ad ! ge ! com
[Download RAW message or body]

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. 

Writing a script to backup .ibd and logfiles shouldn't be that bad, but just wanted \
to make sure if that will be an ideal backup as in online documentation it said this \
is the right way to do if you able to shut down the server.

I know this question was asked numerous times in the list before, but i wasn't able \
to narrow it down to a single solution. If you know any other alternative please let \
me know.

Thanks
Raza

-----Original Message-----
From: Egor Egorov [mailto:egor.egorov@ensita.net]
Sent: Wednesday, February 18, 2004 5:15 AM
To: mysql@lists.mysql.com
Subject: Re: Where to find ibbackup


Jonas Lind?n <jonas.linden@neuronova.com> wrote:
> Hello, I am runing mysql5.x and have just started fiddeling with how I should back \
> up my innodb databases. I started reading about ibbackup and think it suits me. But \
> the problem is I cant find it ;) Does ibbackup come with mysql or should I download \
> it separatly from somewhere else? Anyone using it who could give me a hint?

ibbackup is non-free software and it's not included in the MySQL distribution:
	http://innodb.com/order.php

For backup of InnoDB tables you can also use mysqldump utility:
        http://www.mysql.com/doc/en/mysqldump.html




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@ensita.net
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=Raza.Ansari@ge.com


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com


[prev in list] [next in list] [prev in thread] [next in thread]