#!/bin/bash

dbuser="root"
dbpass="root"

tablename="STREET"

dbout="latin1"
dbin="utf8"

echo "dbf to mysql"
dbf2mysql -h localhost -d ${dbout} -t ${tablename} -P ${dbpass} -U ${dbuser} ${tablename}.DBF

echo "mysqldump w/ latin1"
mysqldump -u${dbuser} -p${dbpass} --hex-blob --default-character-set=latin1 ${dbout} ${tablename} > out.sql

echo "converting - iconv"
iconv -f cp866 -t utf-8 -c out.sql > outtmp.sql

echo "sedddding"
more outtmp.sql|sed 's/latin1/utf8/g' > out.sql

echo "drop data from ${dbin}"
mysql -u${dbuser} -p${dbpass} -e "delete from ${tablename}" ${dbin}

echo "import to database"
mysql --default-character-set=utf8 -u${dbuser} -p${dbpass} ${dbin} < out.sql

echo "deleting temp files"
rm out.sql & rm outtmp.sql

exit 0