ezmlm-mktab
Section: User Commands (1)
Index
Return to Main Contents
NAME
ezmlm-mktab - create SQL table definition for ezmlm list
SYNOPSIS
ezmlm-mktab
[
-dC
]
table_root
DESCRIPTION
ezmlm-mktab
takes
table_root
and prints table definitions for
table_root,
table_root_slog,
etc. All subscriber
and log tables are defined, although normally only a subset are used.
ezmlm-mktab
also can also print the SQL drop commands to remove the same tables.
OPTIONS
- -C
-
Do not print the table definitions for list creation. By default, table
definitions are printed.
- -d
-
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.
USAGE
ezmlm-mktab
-d
list | 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
list,
list_slog,
list_mlog,
the corresponding table sets for address lists
list_allow,
list_deny,
list_digest,
list_mod,
as well as
list_name,
list_digest_name,
list_cookie,
and
list_digest_cookie.
Since the
-d
switch is used, any of these tables already existing are first dropped,
with loss of any data already in them.
SEE ALSO
ezmlm-send(1),
ezmlm(5),
mysql(1)
Index
- NAME
-
- SYNOPSIS
-
- DESCRIPTION
-
- OPTIONS
-
- USAGE
-
- SEE ALSO
-
This document was created by
man2html,
using the manual pages.
Time: 05:37:10 GMT, April 21, 2005