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


Manual Reference Pages  -  FTIMES-CRV2DBI (1)

.ds Aq ’

NAME

ftimes-crv2dbi.pl - Preprocess FTimes carve data for MySQL DB import

CONTENTS

SYNOPSIS

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

DESCRIPTION

This utility takes FTimes carve 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.

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 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 ’carve’.

CAVEATS

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

AUTHOR

Klayton Monroe

SEE ALSO

ftimes-crv2raw(1)

LICENSE

All documentation and code are distributed under same terms and conditions as FTimes.
Search for    or go to Top of page |  Section 1 |  Main Index


perl v5.20.3 FTIMES-CRV2DBI (1) 2016-04-05

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