Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages


home | help
MYDBF2MYSQL(1)		    MyDBF2MySQL	user manual		MYDBF2MYSQL(1)

       mydbf2mysql -- transfer data from DBF files into	MySQL.

       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  configu-
	      ration  and  network  bandwith, so this option have influence on

       -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	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 be-
	      havior 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 af-
	      ter pool is full.	Tune this option to decrease additional	 query

       --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  li-
	      brary 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 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

       The latest version available at

       Bugs should be reported to

Version			10 January 2010			MYDBF2MYSQL(1)


Want to link to this manual page? Use this URL:

home | help