Export Paradox Data: Difference between revisions
From reBiND Documentation
first overview |
save working copy |
||
| Line 22: | Line 22: | ||
=== Installing PX Tools === | === Installing PX Tools === | ||
* http://jan.kneschke.de/projects/pxtools/ | * http://jan.kneschke.de/projects/pxtools/ | ||
<syntaxhighlight lang="bash" enclose="pre"> | |||
tar -zxvf pxtools-0.0.20.tar.gz | tar -zxvf pxtools-0.0.20.tar.gz | ||
cd pxtools-0.0.20/ | cd pxtools-0.0.20/ | ||
| Line 29: | Line 31: | ||
sudo make clean | sudo make clean | ||
pxinfo -f COLEOPTE_DATA.DB | pxinfo -f COLEOPTE_DATA.DB | ||
pxsqldump -d mysql -f | pxsqldump -d mysql -f COLEOPTE_DATA.DB -b COLEOPTE_DATA.MB -d coleopte_data> COLEOPTE_DATA.sql | ||
</syntaxhighlight> | |||
pxconvert.c.477: Read less than requested | |||
pxconvert.c.483: Extract failed: `���A�f,<�� != | |||
pxconvert.c.477: Read less than requested | |||
Speicherzugriffsfehler (Speicherabzug geschrieben) | |||
<syntaxhighlight lang="bash" enclose="pre"> | |||
#!/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 | |||
</syntaxhighlight> | |||
PATH=$PATH:~/bin | |||
chmod +x ~/bin/px2sql.sh | |||
find -name '*.DB' -exec px2sql.sh {} \; | |||
//TODO SQL Join script | |||
//TODO encoding | |||
Revision as of 16:04, 4 June 2012
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
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
Documenting Table Relations
Exporting the data
Installing PX Tools
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
