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