GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages
FTIMES-CMP2DBI(1) FTimes Documentation FTIMES-CMP2DBI(1)

ftimes-cmp2dbi.pl - Preprocess FTimes compare data for MySQL DB import

ftimes-cmp2dbi.pl [-D {default|ignore|replace}] [-d db] [-h host] [-m max-rows] [-o option[,option[,...]]] [-t table] -f {file|-}

This utility takes FTimes compare 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 tables together.

-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 specified, 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 options 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 directly into the .sql file. The default value is 'compare'.

Don't mix host and non host .dbi files as they use different schemas.

Klayton Monroe and Jason Smith

ftimes(1)

All documentation and code are distributed under same terms and conditions as FTimes.
2022-04-08 perl v5.32.1

Search for    or go to Top of page |  Section 1 |  Main Index

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with ManDoc.