1mysql‐zrm‐parse‐binlogs(1) mysql‐zrm‐
2parse‐binlogs(1)
3NNAAMMEE
7 mmyyssqqll‐‐zzrrmm‐‐ppaarrssee‐‐bbiinnllooggss ‐ Utility to parse MySQL binary
8logs for ZRM
9 for MySQL
10SSYYNNOOPPSSIISS
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 [‐‐‐‐ooppttiioonnss‐‐ffiillee _f_i_l_e_n_a_m_e]
21 [‐‐‐‐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]
22 [‐‐‐‐qquuiieett|‐‐‐‐nnoo‐‐qquuiieett]
23 [‐‐‐‐vveerrbboossee]
24 [‐‐‐‐hheellpp]
25DDEESSCCRRIIPPTTIIOONN
28 Parse binary logs to find out the timestamp and/or log po‐
29sition of spe‐
30 cific database events.
31 This utility will display the parsed output of the binary
33logs. This is
34 useful to find out the log positions and/or timestamp to
35be used for
36 restore operations. Either the _s_o_u_r_c_e_‐_d_i_r_e_c_t_o_r_y or the
37_b_i_n_‐_l_o_g_s option
38 should be specified. When the _s_o_u_r_c_e_‐_d_i_r_e_c_t_o_r_y option is
39specified then
40 the parsed output of the binary logs from that backup
41will be dis‐
42 played. When _b_i_n_‐_l_o_g_s option is specified then parsed
43output of the
44 binary log file specified will be displayed.
45 Please take a look at ZRM for MySQL documentation
47(http://mysql‐
48 backup.zmanda.com/) for procedures on how to configure and
49use ZRM for
50 MySQL.
51OOPPTTIIOONNSS
54 ‐‐‐‐bbaacckkuupp‐‐sseett _n_a_m_e
55 Specify backup‐set for the backup run. The de‐
56fault value is
57 _B_a_c_k_u_p_S_e_t_1.
58 ‐‐‐‐ssoouurrccee‐‐ddiirreeccttoorryy _d_i_r_e_c_t_o_r_y _n_a_m_e
60 Choose the directory containing a backup. Both
61_s_o_u_r_c_e_‐_d_i_r_e_c_t_o_r_y
62 and _b_i_n_‐_l_o_g_s options should not be specified.
63If both are
64 present, the utility will throw an error.
65 ‐‐‐‐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 _._._.
67 List binary log files, along with their full paths
68to be used
69 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
70options should
71 not be specified. The utility will throw an error
72if both are
73 specified
74 ‐‐‐‐ppaarrssee‐‐bbiinnllooggss‐‐pplluuggiinn _p_l_u_g_i_n
76 Set the plugin along with full pathname that fil‐
77ters the output
78 of _p_a_r_s_e_‐_b_i_n_l_o_g_s action. This plugin is optional.
79 ‐‐‐‐ppaarrssee‐‐bbiinnllooggss‐‐pplluuggiinn‐‐ooppttiioonnss _"_o_p_t_i_o_n_1 _o_p_t_i_o_n_2 _._._._"
81 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
82the command
83 line arguments.
84 ‐‐‐‐ooppttiioonnss‐‐ffiillee _f_i_l_e_n_a_m_e
86 Set the file along with full pathname that con‐
87tains MySQL com‐
88 mand options.
89 ‐‐‐‐mmyyssqqll‐‐bbiinnppaatthh _M_y_S_Q_L___c_o_m_m_a_n_d___l_o_c_a_t_i_o_n
91 Set the full path where the MySQL binaries are in‐
92stalled. For
93 example: //oopptt//llaammpppp//bbiinn
94 ‐‐‐‐ttmmppddiirr _t_e_m_p___d_i_r_e_c_t_o_r_y
96 Full path of the directory for storing tempo‐
97rary files and
98 directories on the backup host. The default is to
99use the sys‐
100 tem‐specified temporary directory on the backup
101host, e.g. //ttmmpp.
102 ‐‐‐‐qquuiieett|‐‐‐‐nnoo‐‐qquuiieett
104 Choose qquuiieett to suppress display of log messages
105on ssttddoouutt.
106 Choose nnoo‐‐qquuiieett to display the log messages
107to ssttddoouutt. The
108 default is ‐‐‐‐nnoo‐‐qquuiieett.
109 ‐‐‐‐vveerrbboossee
111 Provide more detailed output in the log. Ver‐
112bose output is
113 turned off by default.
114 ‐‐‐‐hheellpp Displays the help message and exits. This com‐
116mand‐line‐only
117 parameter cannot be specified in the configuration
118file.
119EEXXAAMMPPLLEESS
121 mmyyssqqll‐‐zzrrmm ‐‐‐‐aaccttiioonn ppaarrssee‐‐bbiinnllooggss ‐‐‐‐bbiinn‐‐llooggss
122//vvaarr//lliibb//mmyyssqqll‐‐zzrrmm//bbaacckk‐‐
123 uuppsseett11//2200006600881188112211553322//mmyyssqqll‐‐bbiinn..[[00‐‐99]]**
124//vvaarr//lliibb//mmyyssqqll‐‐zzrrmm//bbaacckk‐‐
125 uuppsseett11//2200006600881199112211553322//mmyyssqqll‐‐bbiinn..[[00‐‐99]]**
126 The above command parses and displays the relevant con‐
128tents of all
129 specified binary log files. Use it to find out what
130position and or
131 timestamp to specify for selective restores.
132FFIILLEESS
135 //vvaarr//lliibb//mmyyssqqll‐‐zzrrmm
136 Directory under which all backup data is stored.
137 //eettcc//mmyyssqqll‐‐zzrrmm//_b_a_c_k_u_p _s_e_t _n_a_m_e//mmyyssqqll‐‐zzrrmm..ccoonnff
140 Configuration file read by ZRM for MySQL.
141RREETTUURRNN VVAALLUUEESS
144 On success, zero is returned. On error, non‐zero value is
145returned.
146SSEEEE AALLSSOO
149 mysql‐zrm(1), mysql‐zrm‐backup(1), mysql‐zrm‐man‐
150age‐backup(1),
151 mysql‐zrm‐restore(1), mysql‐zrm‐check(1),
152mysql‐zrm‐list(1),
153 mysql‐zrm‐getconf(1), mysql‐zrm‐setconf(1), mysql‐
154zrm‐purge(1),
155 mysql‐zrm‐extract‐backup(1), mysql‐zrm‐ver‐
156ify‐backup(1),
157 mysql‐zrm‐abort‐backup(1), mysql‐zrm‐
158scheduler(1),
159 mysql‐zrm‐reporter(1), mysql‐zrm.conf(5), mysqldump(1),
160mysqlbinlog(1),
161 mysql(1), lvm(8), Zmanda Recovery Manager for MySQL
162(http://mysql‐
163 backup.zmanda.com/)
164AAUUTTHHOORR
167 Zmanda Inc. (http://www.zmanda.com)
168Zmanda, Inc. ZRM for MySQL 2.1 mysql‐zrm‐
172parse‐binlogs(1)
173