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 users 175K Sep 14 14:21 hrrgp01-bin.000007 > > -rw-rw---- 1 mysql users 345K Sep 14 15:03 hrrgp01-bin.000008 > > -rw-rw---- 1 mysql users 1.6M Sep 14 15:18 hrrgp01-bin.000009 > > -rw-rw---- 1 mysql users 3.9M Sep 15 09:06 hrrgp01-bin.000010 > > -rw-rw---- 1 mysql users 29K Sep 15 09:11 hrrgp01-bin.000011 > > -rw-rw---- 1 mysql users 676K Sep 15 15:58 hrrgp01-bin.000012 > > -rw-rw---- 1 mysql users 4.4M Sep 16 11:10 hrrgp01-bin.000016 > > -rw-rw---- 1 mysql mysql 322M 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]
