Egor Egorov wrote:
>Mauricio Pellegrini <hrrg-inf@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
