DBase III
Dan Tobias (Talk | contribs) (→Additional Weblinks) |
Dan Tobias (Talk | contribs) |
||
| Line 24: | Line 24: | ||
The data can then be exported using <code>mysqldump</code> | The data can then be exported using <code>mysqldump</code> | ||
user@linux:~$ mysqldump -u root -p database_name > data_export.sql | user@linux:~$ mysqldump -u root -p database_name > data_export.sql | ||
| + | |||
| + | == Specifications == | ||
| + | |||
| + | * [http://www.dbase.com/Knowledgebase/INT/db7_file_fmt.htm dBase version 7 file header format] | ||
| + | |||
| + | == Metaformat files == | ||
| + | |||
| + | * [https://www.synalysis.net/Grammars/dbase.grammar Synalysis grammar file] (for Hexinator / Synalize It!; [[Synalysis grammar file|more details]]) | ||
== See also == | == See also == | ||
Revision as of 03:41, 25 January 2015
This article describes how to export data out of a dBase III Table File (*.dbf).
Contents |
Opening the data with Libre Office
It is possible to import *.dbf files into Libre Office (or Open Office) Calc or Base: http://help.libreoffice.org/Calc/Importing_and_Exporting_dBASE_Files .
Libre Office will try to recognize the character encoding of the data and preselect this option in the import window. Once a file imported, it can be saved in/exported to a variety of different formats.
Importing the data directly into a mySQL database
Alternatively the data can directly be imported into a running mySQL database using the linux program dbf2mysql. Importing the data directly however could cause some problems with the character encoding for non ASCII characters.
If the mysql server is already running, the following commands will import the data:
user@linux:~$ mysql -u root -p mysql> create database database_name; mysql> exit user@linux:~$ sudo apt-get install dbf2mysql user@linux:~$ dbf2mysql -vvv -c -f -d database_name -U root -P password DATA_FILE.DBF
The data can then be exported using mysqldump
user@linux:~$ mysqldump -u root -p database_name > data_export.sql
Specifications
Metaformat files
- Synalysis grammar file (for Hexinator / Synalize It!; more details)
