ezmlm-mktab(1) ezmlm-mktab(1) NNAAMMEE ezmlm-mktab - create SQL table definition for ezmlm list SSYYNNOOPPSSIISS eezzmmllmm--mmkkttaabb [ --ddCC ] _t_a_b_l_e___r_o_o_t DDEESSCCRRIIPPTTIIOONN eezzmmllmm--mmkkttaabb takes _t_a_b_l_e___r_o_o_t and prints table definitions for _t_a_- _b_l_e___r_o_o_t, _t_a_b_l_e___r_o_o_t__sslloogg, etc. All subscriber and log tables are defined, although normally only a subset are used. eezzmmllmm--mmkkttaabb also can also print the SQL drop commands to remove the same tables. OOPPTTIIOONNSS --CC Do not print the table definitions for list creation. By default, table definitions are printed. --dd Print table drop commands. Normally, they are omitted. When printed, they are printed before the table definitions, so that existing tables are removed, then recreated. UUSSAAGGEE eezzmmllmm--mmkkttaabb --dd _l_i_s_t | mysql -hhost -uuser -p -f db This connects to the mysql server on ‘‘host’’ as ‘‘user’’ (prompting for the password) and in database ‘‘db’’ creates tables _l_i_s_t, _l_i_s_t__sslloogg, _l_i_s_t__mmlloogg, the corresponding table sets for address lists _l_i_s_t__aallllooww, _l_i_s_t__ddeennyy, _l_i_s_t__ddiiggeesstt,, _l_i_s_t__mmoodd,, as well as _l_i_s_t__nnaammee, _l_i_s_t__ddiiggeesstt__nnaammee, _l_i_s_t__ccooookkiiee, and _l_i_s_t__ddiiggeesstt__ccooookkiiee. Since the --dd switch is used, any of these tables already existing are first dropped, with loss of any data already in them. SSEEEE AALLSSOO ezmlm-send(1), ezmlm(5), mysql(1) ezmlm-mktab(1)