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]