1mysql‐zrm‐parse‐binlogs(1)                             mysql‐zrm‐
2parse‐binlogs(1)
3
4
5
6NNAAMMEE
7       mmyyssqqll‐‐zzrrmm‐‐ppaarrssee‐‐bbiinnllooggss  ‐  Utility  to parse MySQL binary
8logs for ZRM
9       for MySQL
10
11SSYYNNOOPPSSIISS
12       mmyyssqqll‐‐zzrrmm‐‐ppaarrssee‐‐bbiinnllooggss
13                       [‐‐‐‐ssoouurrccee‐‐ddiirreeccttoorryy _d_i_r___n_a_m_e]
14                       [‐‐‐‐bbiinn‐‐llooggss               _"_/_f_u_l_l_p_a_t_h_/_n_a_m_e_1
15_/_f_u_l_l_p_a_t_h_/_n_a_m_e_2 _._._._"]
16                       [‐‐‐‐mmyyssqqll‐‐bbiinnppaatthh _M_y_S_Q_L___c_o_m_m_a_n_d___l_o_c_a_t_i_o_n]
17                       [‐‐‐‐ppaarrssee‐‐bbiinnllooggss‐‐pplluuggiinn _p_l_u_g_i_n]
18                       [‐‐‐‐ppaarrssee‐‐bbiinnllooggss‐‐pplluuggiinn‐‐ooppttiioonnss _"_o_p_t_1 _o_p_t_2
19_._._._"]
20                       [‐‐‐‐rrooww‐‐eevveenntt‐‐ddeettaaiillss== _n_e_v_e_r_|_a_l_w_a_y_s_|_a_u_t_o]
21                       [‐‐‐‐oouuttppuutt‐‐ffoorrmmaatt== _h_t_m_l_|_t_e_x_t]
22                       [‐‐‐‐ooppttiioonnss‐‐ffiillee _f_i_l_e_n_a_m_e]
23                       [‐‐‐‐ttmmppddiirr _t_e_m_p_o_r_a_r_y _d_i_r_e_c_t_o_r_y _t_o _b_e _u_s_e_d]
24                       [‐‐‐‐qquuiieett|‐‐‐‐nnoo‐‐qquuiieett]
25                       [‐‐‐‐vveerrbboossee]
26                       [‐‐‐‐hheellpp]
27
28
29DDEESSCCRRIIPPTTIIOONN
30       Parse binary logs to find out the timestamp and/or log po‐
31sition of spe‐
32       cific database events.
33
34       This utility will display the parsed output of the  binary
35logs. This is
36       useful  to  find out the log positions and/or timestamp to
37be  used  for
38       restore  operations. Either the  _s_o_u_r_c_e_‐_d_i_r_e_c_t_o_r_y  or  the
39_b_i_n_‐_l_o_g_s option
40       should  be  specified. When the _s_o_u_r_c_e_‐_d_i_r_e_c_t_o_r_y option is
41specified then
42       the  parsed  output  of  the  binary logs from that backup
43will be dis‐
44       played.  When  _b_i_n_‐_l_o_g_s  option  is specified then  parsed
45output  of  the
46       binary log file specified will be displayed.
47
48       Please  take  a  look  at  ZRM  for   MySQL  documentation
49(http://mysql
50       backup.zmanda.com/) for procedures on how to configure and
51use ZRM  for
52       MySQL.
53
54
55OOPPTTIIOONNSS
56       ‐‐‐‐bbaacckkuupp‐‐sseett _n_a_m_e
57              Specify  backup‐set  for  the  backup  run. The de‐
58fault value is
59              _B_a_c_k_u_p_S_e_t_1.
60
61       ‐‐‐‐ssoouurrccee‐‐ddiirreeccttoorryy _d_i_r_e_c_t_o_r_y _n_a_m_e
62              Choose  the  directory  containing  a  backup. Both
63_s_o_u_r_c_e_‐_d_i_r_e_c_t_o_r_y
64              and  _b_i_n_‐_l_o_g_s  options  should  not  be  specified.
65If both are
66              present, the utility will throw an error.
67
68       ‐‐‐‐bbiinn‐‐llooggss _"_/_f_u_l_l_p_a_t_h_/_n_a_m_e_1 _/_f_u_l_l_p_a_t_h_/_n_a_m_e_2 _._._.
69              List  binary log files, along with their full paths
70to  be  used
71              for  restore.  Both _s_o_u_r_c_e_‐_d_i_r_e_c_t_o_r_y  and  _b_i_n_‐_l_o_g_s
72options should
73              not  be  specified. The utility will throw an error
74if  both  are
75              specified
76
77       ‐‐‐‐ppaarrssee‐‐bbiinnllooggss‐‐pplluuggiinn _p_l_u_g_i_n
78              Set  the plugin along with full pathname that  fil‐
79ters the output
80              of _p_a_r_s_e_‐_b_i_n_l_o_g_s action.  This plugin is optional.
81
82       ‐‐‐‐ppaarrssee‐‐bbiinnllooggss‐‐pplluuggiinn‐‐ooppttiioonnss _"_o_p_t_i_o_n_1 _o_p_t_i_o_n_2 _._._._"
83              Pass  options to the _p_a_r_s_e_‐_b_i_n_l_o_g_s_‐_p_l_u_g_i_n as one of
84the  command
85              line arguments.
86
87       ‐‐‐‐rrooww‐‐eevveenntt‐‐ddeettaaiillss== _n_e_v_e_r_|_a_l_w_a_y_s_|_a_u_t_o
88              This  option  describes  how  the  row  replication
89events in binary
90              logs  should be handled. If the _m_y_s_q_l_b_i_n_l_o_g command
91on  the  ZRM
92              server  supports  decoding  row  based  replication
93events and sup‐
94              ports   verbose  mode  (MySQL  client  versions   >
955.1.28),  set  the
96              value to _a_l_w_a_y_s.  Set the value to _n_e_v_e_r if the row
97based repli‐
98              cation   events   decoding   is  not  supported  by
99_m_y_s_q_l_b_i_n_l_o_g  command.
100              Set the value to _a_u_t_o if ZRM should parse row based
101events if it
102              is  supported.   Support  of this feature is deter‐
103mined by ZRM when
104              the value is _a_u_t_o.
105
106       ‐‐‐‐oouuttppuutt‐‐ffoorrmmaatt== _h_t_m_l_|_t_e_x_t
107              The  output  from the command can be in text format
108(value _t_e_x_t)
109              or in form of HTML table (value _h_t_m_l).  The default
110is the  text
111              format.
112
113       ‐‐‐‐ooppttiioonnss‐‐ffiillee _f_i_l_e_n_a_m_e
114              Set  the  file along with full pathname  that  con‐
115tains MySQL com‐
116              mand options.
117
118       ‐‐‐‐mmyyssqqll‐‐bbiinnppaatthh _M_y_S_Q_L___c_o_m_m_a_n_d___l_o_c_a_t_i_o_n
119              Set the full path where the MySQL binaries are  in‐
120stalled.   For
121              example: //oopptt//llaammpppp//bbiinn
122
123       ‐‐‐‐ttmmppddiirr _t_e_m_p___d_i_r_e_c_t_o_r_y
124              Full  path  of  the  directory  for  storing tempo‐
125rary files and
126              directories  on  the backup host. The default is to
127use  the  sys‐
128              tem‐specified temporary  directory  on  the  backup
129host, e.g. //ttmmpp.
130
131       ‐‐‐‐qquuiieett|‐‐‐‐nnoo‐‐qquuiieett
132              Choose qquuiieett to suppress display  of  log  messages
133on  ssttddoouutt.
134              Choose  nnoo‐‐qquuiieett  to  display  the   log   messages
135to ssttddoouutt. The
136              default is ‐‐‐‐nnoo‐‐qquuiieett.
137
138       ‐‐‐‐vveerrbboossee
139              Provide  more  detailed output  in  the  log.  Ver‐
140bose  output  is
141              turned off by default.
142
143       ‐‐‐‐hheellpp Displays  the  help  message  and  exits. This com‐
144mand‐line‐only
145              parameter  cannot be specified in the configuration
146file.
147
148EEXXAAMMPPLLEESS
149       mmyyssqqll‐‐zzrrmm     ‐‐‐‐aaccttiioonn      ppaarrssee‐‐bbiinnllooggss       ‐‐‐‐bbiinn‐‐llooggss
150//vvaarr//lliibb//mmyyssqqll‐‐zzrrmm//bbaacckk‐‐
151       uuppsseett11//2200006600881188112211553322//mmyyssqqll‐‐bbiinn..[[00‐‐99]]**
152//vvaarr//lliibb//mmyyssqqll‐‐zzrrmm//bbaacckk‐‐
153       uuppsseett11//2200006600881199112211553322//mmyyssqqll‐‐bbiinn..[[00‐‐99]]**
154
155       The above command parses and displays  the  relevant  con‐
156tents  of  all
157       specified   binary   log   files.  Use it to find out what
158position and or
159       timestamp to specify for selective restores.
160
161
162FFIILLEESS
163       //vvaarr//lliibb//mmyyssqqll‐‐zzrrmm
164              Directory under which all backup data is stored.
165
166
167       //eettcc//mmyyssqqll‐‐zzrrmm//_b_a_c_k_u_p _s_e_t _n_a_m_e//mmyyssqqll‐‐zzrrmm..ccoonnff
168              Configuration file read by ZRM for MySQL.
169
170
171RREETTUURRNN VVAALLUUEESS
172       On success, zero is returned. On error, non‐zero value  is
173returned.
174
175
176SSEEEE AALLSSOO
177       mysql‐zrm(1),     mysql‐zrm‐backup(1),      mysql‐zrm‐man‐
178age‐backup(1),
179       mysql‐zrm‐restore(1),                  mysql‐zrm‐check(1),
180mysql‐zrm‐list(1),
181       mysql‐zrm‐getconf(1),     mysql‐zrm‐setconf(1),     mysql‐
182zrm‐purge(1),
183       mysql‐zrm‐extract‐backup(1),                mysql‐zrm‐ver‐
184ify‐backup(1),
185       mysql‐zrm‐abort‐backup(1),                      mysql‐zrm‐
186scheduler(1),
187       mysql‐zrm‐reporter(1),  mysql‐zrm.conf(5),   mysqldump(1),
188mysqlbinlog(1),
189       mysql(1),  lvm(8),  Zmanda   Recovery  Manager  for  MySQL
190(http://mysql
191       backup.zmanda.com/)
192
193
194AAUUTTHHOORR
195       Zmanda Inc. (http://www.zmanda.com)
196
197
198
199Zmanda, Inc.                    ZRM  for  MySQL        mysql‐zrm‐
200parse‐binlogs(1)
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
Impressum