MYDBF2MYSQL(1) MyDBF2MySQL user manual MYDBF2MYSQL(1)NAME
mydbf2mysql -- transfer data from DBF files into MySQL.
USAGE
mydbf2mysql options
DESCRIPTION
MyDBF2MySQL is a tool which allows to import random data sets from DBF
files into RDBMS MySQL. Using provided options you can control server
load balance. The program designed to work without user interact.
OPTIONS--version
Show MyDBF2MySQL version number and exit.
-h, --help
Show help message and exit.
-W N, --worker-threads N
Set N as a number of threads working in the same time (entire
process is divided between them). It is recomended to use less
threads for small files and more than two threads for big. Some
times too much treads have no sens because your server configu‐
ration and network bandwith, so this option have influence on
performance.
-s N, --skip N
Skip N records from null record before import start.
-c N, --count N
Set amount of records to process to N, in combination with -s
option you can cut any interval of records.
-q, --quiet, --critical
The highest level, only CRITICAL error are shown.
--error
Set logging level to ERROR , in this level only error and criti‐
cal errors are printed.
-w, --warnings
Set logging level to WARN, in this level both errors and warn‐
ings are printed.
-I, --interactive-output
Print run-time information including number of proccessed
records, errors and percentage. Using this option will slow down
the proccess. This output is on INFO logging level as yet.
-i, --information
Set logging level to INFO.
-d, --debug
Set logging level to DEBUG (lowest level).
-r ATTEMPTS, --reconnect ATTEMPTS
On the connection lose, automatically try to reconnect within a
second. By default, make reconnect attempts in endless loop
each time the connection is lost. To suppress reconnection
behavior set ATTEMPTS to 0 or specify ATTEMPTS count.
-t, --truncate-table
Truncate table before import begin.
-O, --optimize-table
Perform optimization query, after truncate query.
--skip-checks
Skip some consistency and DBF format checks.
--insert-pool COUNT
Set COUNT as the number of records inserted by each query. The
data will be agregated in the pool and flushed to the server
after pool is full. Tune this option to decrease additional
query charges.
--time-out SECONDS
Set SECONDS as maximum connection time out.
-u LOGIN, --user-name LOGIN
Set the MySQL username to connect as LOGIN.
-U SOCKET, --unix-socket SOCKET
Location of UNIX socket to use (instead of TCP connection).
-n, --named-pipe
Named pipe (windows) to connect (instead of TCP connection).
-H ADDRESS, --host ADDRESS
Connect to the MySQL server on the given ADDRESS.
-p PORT, --port PORT
Set MySQL service port to PORT.
-P PASSWD, --password PASSWD
Set PASSWD as password to use when connecting to the server.
-C, --compress
Compress all information sent between the client and the server
if both support compression.
-D NAME, --databse NAME
Set data base name as NAME.
-S FIELDS, --sql-fields FIELDS
Set FIELDS as target MySQL columns, must be comma separated.
Each one field correspond to source DBF field.
-F FIELDS, --fields FIELDS
FIELDS must be comma separated. After the field name, colon sep‐
arated, may be specified filter. Data will be passed trought the
filter and converted if possible, no warnings will be printed.
Numeric filters: int to convert to integer, float to convert to
float. Other filters: ebz2 to encode to bzip2, dbz2 to decode
from bzip2. The common notation:
Name[:filter], Name1[:filter], ... , NameN[:filter].
-f FILE, --file FILE
Name of the DBF file of supported type. Now the underlying
library ydbf supports only dBASE III and dBASE IV.
--describe FILE
This option may be combined with --skip-checks only. In this
way, program lists field names, file signature, records count
and exit.
-l, --list-constants
Print supported encodings, formats, filters. Any other spicified
options are ignored.
EXIT CODES
Full list of exit codes with description:
0 Success
2 Bad option
24 Bad parameter
32 Input/output failure
40 Inconsistent DBF format
64 RDBMS failure
128 General failure
EXAMPLES
A typical call is shown in example below. The only arguments used in
this example are -I to see how fast the proccess going on, -t to trun‐
cate table, -T to set a table name, -D to set a DB name, -f to set
file. The -S, -F options are set up correspondence between DBF and
MySQL columns. In this example field Hst should be inserted into SQL
column HST and Prt into PRT in table Tname of test database.
mydbf2mysql -It -D test -S HST,PRT -F Hst,Prt -T Tname -f x.dbf
To see the file structure use --describe option as below:
mydbf2mysql --describe /home/alex/alex.dbf
URL
The latest version available at http://mydbf2mysql.sourceforge.net/.
BUGS
Bugs should be reported to andrey@polyakov.name.
Version 0.8.4.5 10 January 2010 MYDBF2MYSQL(1)