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:[EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 5:15 AM To: [EMAIL PROTECTED] Subject: Re: Where to find ibbackup Jonas Lind?n <[EMAIL PROTECTED]> 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]