Re: Which file to backup
Yes , I'm using innodb. Is it necesary to do a mysqladmin flush-logs before making a copy of ib_logfile* or must the server go down to do a safe copy of the ib_logfiles ? thanks Mauricio On Fri, 2004-09-17 at 09:08, Egor Egorov wrote: Mauricio Pellegrini [EMAIL PROTECTED] wrote: I'm trying to backup the 'binary log' and don't know which file is it. these are the files I see in my datadir -rw-rw 1 mysql users175K Sep 14 14:21 hrrgp01-bin.07 -rw-rw 1 mysql users345K Sep 14 15:03 hrrgp01-bin.08 -rw-rw 1 mysql users1.6M Sep 14 15:18 hrrgp01-bin.09 -rw-rw 1 mysql users3.9M Sep 15 09:06 hrrgp01-bin.10 -rw-rw 1 mysql users 29K Sep 15 09:11 hrrgp01-bin.11 -rw-rw 1 mysql users676K Sep 15 15:58 hrrgp01-bin.12 -rw-rw 1 mysql users4.4M Sep 16 11:10 hrrgp01-bin.16 -rw-rw 1 mysql mysql322M Sep 16 11:10 ibdata1 -rw-rw 1 mysql users 40M Sep 16 11:10 ib_logfile0 The thing is I intend to stop the server at a certain time and then make a backup copy of the actual binary log. But which is the name of the file I should use into my script? Backup *-bin.* and ib_logfile* if you use InnoDB. -- 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]
Re: Which file to backup
Luciano Barcaro [EMAIL PROTECTED] wrote: I'm trying to backup the 'binary log' and don't know which file is it. these are the files I see in my datadir -rw-rw 1 mysql users175K Sep 14 14:21 hrrgp01-bin.07 -rw-rw 1 mysql users345K Sep 14 15:03 hrrgp01-bin.08 -rw-rw 1 mysql users1.6M Sep 14 15:18 hrrgp01-bin.09 -rw-rw 1 mysql users3.9M Sep 15 09:06 hrrgp01-bin.10 -rw-rw 1 mysql users 29K Sep 15 09:11 hrrgp01-bin.11 -rw-rw 1 mysql users676K Sep 15 15:58 hrrgp01-bin.12 -rw-rw 1 mysql users4.4M Sep 16 11:10 hrrgp01-bin.16 -rw-rw 1 mysql mysql322M Sep 16 11:10 ibdata1 -rw-rw 1 mysql users 40M Sep 16 11:10 ib_logfile0 The thing is I intend to stop the server at a certain time and then make a backup copy of the actual binary log. But which is the name of the file I should use into my script? Backup *-bin.* and ib_logfile* if you use InnoDB. And don?t forget ibdata1 The question was about logs. -- 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]
Re: Which file to backup
Mauricio Pellegrini [EMAIL PROTECTED] wrote: I'm trying to backup the 'binary log' and don't know which file is it. these are the files I see in my datadir -rw-rw 1 mysql users175K Sep 14 14:21 hrrgp01-bin.07 -rw-rw 1 mysql users345K Sep 14 15:03 hrrgp01-bin.08 -rw-rw 1 mysql users1.6M Sep 14 15:18 hrrgp01-bin.09 -rw-rw 1 mysql users3.9M Sep 15 09:06 hrrgp01-bin.10 -rw-rw 1 mysql users 29K Sep 15 09:11 hrrgp01-bin.11 -rw-rw 1 mysql users676K Sep 15 15:58 hrrgp01-bin.12 -rw-rw 1 mysql users4.4M Sep 16 11:10 hrrgp01-bin.16 -rw-rw 1 mysql mysql322M Sep 16 11:10 ibdata1 -rw-rw 1 mysql users 40M Sep 16 11:10 ib_logfile0 The thing is I intend to stop the server at a certain time and then make a backup copy of the actual binary log. But which is the name of the file I should use into my script? Backup *-bin.* and ib_logfile* if you use InnoDB. -- 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]
Re: Which file to backup
Egor Egorov wrote: Mauricio Pellegrini [EMAIL PROTECTED] wrote: I'm trying to backup the 'binary log' and don't know which file is it. these are the files I see in my datadir -rw-rw 1 mysql users175K Sep 14 14:21 hrrgp01-bin.07 -rw-rw 1 mysql users345K Sep 14 15:03 hrrgp01-bin.08 -rw-rw 1 mysql users1.6M Sep 14 15:18 hrrgp01-bin.09 -rw-rw 1 mysql users3.9M Sep 15 09:06 hrrgp01-bin.10 -rw-rw 1 mysql users 29K Sep 15 09:11 hrrgp01-bin.11 -rw-rw 1 mysql users676K Sep 15 15:58 hrrgp01-bin.12 -rw-rw 1 mysql users4.4M Sep 16 11:10 hrrgp01-bin.16 -rw-rw 1 mysql mysql322M Sep 16 11:10 ibdata1 -rw-rw 1 mysql users 40M Sep 16 11:10 ib_logfile0 The thing is I intend to stop the server at a certain time and then make a backup copy of the actual binary log. But which is the name of the file I should use into my script? Backup *-bin.* and ib_logfile* if you use InnoDB. And don´t forget ibdata1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Which file to backup
Sorry for my bad English!! From: Mauricio Pellegrini [EMAIL PROTECTED] To: MySql List [EMAIL PROTECTED] Subject: Wich file to backup Date: 16 Sep 2004 11:28:56 -0700 Hi , I'm trying to backup the 'binary log' and don't know which file is it. these are the files I see in my datadir -rw-rw 1 mysql users175K Sep 14 14:21 hrrgp01-bin.07 -rw-rw 1 mysql users345K Sep 14 15:03 hrrgp01-bin.08 -rw-rw 1 mysql users1.6M Sep 14 15:18 hrrgp01-bin.09 -rw-rw 1 mysql users3.9M Sep 15 09:06 hrrgp01-bin.10 -rw-rw 1 mysql users 29K Sep 15 09:11 hrrgp01-bin.11 -rw-rw 1 mysql users676K Sep 15 15:58 hrrgp01-bin.12 -rw-rw 1 mysql users4.4M Sep 16 11:10 hrrgp01-bin.16 -rw-rw 1 mysql mysql322M Sep 16 11:10 ibdata1 -rw-rw 1 mysql users 40M Sep 16 11:10 ib_logfile0 The thing is I intend to stop the server at a certain time and then make a backup copy of the actual binary log. But which is the name of the file I should use into my script? Thanks Mauricio -- 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]
