---
name: "msql2dbf"
section: "1"
platform: "linux"
package: "dbf2msql"
version: "2.0-6"
release: "Debian 2.1 (Slink)"
platforms: ["linux"]
url: "https://new.carta.tech/msql2dbf"
---

# msql2dbf(1)

Generate xBase-style .dbf-files from SQL-tables

## NAME

sql2dbf - Generate xBase-style .dbf-files from SQL-tables

## SYNOPSIS

**msql2dbf \[options\] dbf-file**\
\
 Options:\
 \[-v\[v\]\] \[-u \| -l\] \[-d database\] \[-t table\] \[-h host\] \[-d\] \[-q query\] \[-p precision\]

## DESCRIPTION

This manual page documents the program **msql2dbf.** This takes a table, and writes out an xBase-style .dbf-file with the contents of that table.

### OPTIONS

- *-v*

  Display some status-messages.

- *-vv*

  Also display progress.

- *-u*

  Convert the contents of all fields to uppercase.

- *-l*

  Convert the contents of all fields to lowercase.

- *-d database*

  Specify the database to use. An error is returned if this database does not exists. Default is "test".

- *-t table*

  Specifies the table to select from. An error is returned if this database does not exists. Default is "test".

- *-h host*

  Specify the host to which to connect. Default is "localhost".

- *-q*

  Specify a custom query to use to fetch the data out of the table (or tables).

- *-p precision*

  Specify the precision to use in the case of a **REAL** field. This is the part after the decimal point.

## ENVIRONMENT

These programs are effected by the environment-variables as used by **mSQL.** See the documentation of mSQL for more information on this.

## BUGS

At the moment none that I know, except for some lacking functionallity.

## AVAILABILITY

You can get the latest version by anonymous FTP from **ftp.nerosworld.com/pub/msql/contrib/dbf2msql**