Luciano Barcaro <barcaro@stripped> 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
/ /|_/ / // /\ \/ /_/ / /__ Egor.Egorov@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
