FTIMES-MAP2DBI(1) FTimes Documentation FTIMES-MAP2DBI(1) NAME ftimes-map2dbi.pl - Preprocess FTimes map data for MySQL DB import SYNOPSIS ftimes-map2dbi.pl [-D {default|ignore|replace}] [-d db] [-h host] [-m max-rows] [-o option[,option[,...]]] [-t table] -f {file|-} DESCRIPTION This utility takes FTimes map data as input, processes it, and produces two output files having the extensions .sql and .dbi. The SQL statements in the .sql file may be used to import the .dbi data into MySQL -- dbi is short for DB Import. An extra field, joiner, is added to the .dbi file. This field serves as the primary key -- either alone or in conjunction with the hostname field. It can also be used as a joining key to tie map and dig ta- bles together. OPTIONS -D {default|ignore|replace} Add the IGNORE or REPLACE keyword to the LOAD statement. The default value is 'default', which means don't alter the LOAD statement. -d db Specifies the name of the database to create/use. This value is passed directly into the .sql file. The default value is 'ftimes'. -f {file|-} Specifies the name of the input file. A value of '-' will cause the program to read from stdin. If input is read from stdin, the output files will be placed in the current directory and have a basename of 'stdin'. -h host Specifies the name of the host to bind to the imported data. If speci- fied, an additional field, hostname, is inserted in the .dbi file and filled with the appropriate value. By default, the hostname field is not used. -m max-rows Limits the number of records that may be inserted into the specified database. This value is passed directly into the .sql file as MAX_ROWS. -o option,[option[,...]] Specifies the list of options to apply. Currently, the following op- tions are supported: ForceWrite Force existing .sql and .dbi files to be truncated on open. LocalInFile Add the LOCAL keyword to the LOAD statement. When this keyword is specified, the .dbi file is read by the local MySQL client and sent to the remote MySQL server. UseMergeTables Append the hostname, if defined, as a suffix on the table name. This allows data for each unique host to be loaded into separate tables that can be linked together using MySQL MERGE tables. -t table Specifies the name of the table to create/use. This value is passed di- rectly into the .sql file. The default value is 'map'. CAVEATS Don't mix UNIX and WINX snapshots as they use different schemas. Don't mix host and non host .dbi files for the same reason. AUTHOR Klayton Monroe SEE ALSO ftimes(1) LICENSE All documentation and code are distributed under same terms and conditions as FTimes. perl v5.42.3 2026-08-27 FTIMES-MAP2DBI(1)
NAME | SYNOPSIS | DESCRIPTION | OPTIONS | CAVEATS | AUTHOR | SEE ALSO | LICENSE
Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=ftimes-map2dbi&sektion=1&manpath=FreeBSD+Ports+15.1.quarterly>