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 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. >> >> >> >> > 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]