Export Paradox Data

Export Paradox Data

This article describes how to export data from Paradox Database files, based on the data set provided by the Museum König.

Introduction

Further Reading

• A Brief Tour of Paradox Database Files
• Understanding File-System Databases

Viewing the Data

• Paradox dbase Reader
• Paradox Viewer 30 day trial version

Paradox 5.0 and 7.0: jIGGAe or cupcdvum Paradox 4.0: nx66ppx

Removing Password Protection

• Paradox Data Editor

Exporting the data

Installing PX Tools

• http://jan.kneschke.de/projects/pxtools/

 tar -zxvf pxtools-0.0.20.tar.gz
 cd pxtools-0.0.20/
 ./configure
 sudo make
 sudo make install
 sudo make clean
 pxinfo -f COLEOPTE_DATA.DB
 pxsqldump -d mysql -f COLEOPTE_DATA.DB -b COLEOPTE_DATA.MB -d coleopte_data> COLEOPTE_DATA.sql

pxconvert.c.477: Read less than requested
pxconvert.c.483: Extract failed: `���A�f,<�� != 
pxconvert.c.477: Read less than requested
Speicherzugriffsfehler (Speicherabzug geschrieben)

 #!/bin/sh
 if [ ! -d "sql" ]; then 
 	mkdir sql
 fi
 echo 
 echo "#############################"
 echo "# Exporting $1"
 echo "#############################"
 pxsqldump -d mysql -f $1 -b $(echo "$1" | sed -e 's/\.DB$/\.MB/') -n $(echo "$1" | tr '[:upper:]' '[:lower:]'| sed -e 's/\.db$//' | sed -e 's/.*\///') > sql/$1.sql

PATH=$PATH:~/bin
chmod +x ~/bin/px2sql.sh
find -name '*.DB' -exec px2sql.sh {} \;

//TODO SQL Join script //TODO encoding