Quick Navigator

Search Site

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

Contact Us
Online Help
Domain Status
Man Pages

Virtual Servers

Topology Map

Server Agreement
Year 2038

USA Flag



Man Pages

Manual Reference Pages  -  MYDBF2MYSQL (1)


mydbf2mysql -- transfer data from DBF files into MySQL.


Exit Codes


mydbf2mysql options


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.


  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 configuration 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.
  Set logging level to ERROR , in this level only error and critical errors are printed.
-w, --warnings
  Set logging level to WARN, in this level both errors and warnings 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 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).
  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 separated, 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.


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


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 truncate 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


The latest version available at


Bugs should be reported to
Search for    or go to Top of page |  Section 1 |  Main Index

Version MYDBF2MYSQL (1) 10 January 2010

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