vtable.1

NAME

vtable - create MySQL table from text file templates

SYNOPSYS

vtable [options] template1 template2 ...

DESCRIPTION

vtable can create MySQL tables from simple template specfied in a text file. A text file containg the following content can be used to create a MySQL table dbinfo with two indices as given below.

dbinfo
(filename char(128) not null,
domain   char(64) not null,
distributed int not null,
server   char(28) not null,
mdahost  char(28) not null,
port     int not null,
dbname   char(28) not null,
user     char(28) not null,
passwd   char(28) not null,
timestamp timestamp not null,
unique index (filename, domain, server, mdahost, port, dbname, user, passwd), 
index (domain))

vtable helps you to maintain your customized MySQL table structures in simple text files so that they can be recreated easily at any point of time. You can give multiple filenames on the command line to create multiple tables in a single invocation of vtable.

OPTIONS

-v
Sets verbose option

-S IP
MySQL Server IP

-p port
MySQL TCP/IP Port

-s socket
MySQL Unix Domain Socket. You can specify this instead of port if your MySQL server is local.

-D database
MySQL Database Name

-U user
MySQL User Name

-P password
MySQL Password

template1, template2 are filenames each containing a template representing a MySQL table structure.

RETURN VALUE

Returns 0 for success, 1 for any failure.

SEE ALSO

IndiMail(7) install_tables(8),