*nix
====

It's probably easier to use foonrip's built in mysql import option:

./foonrip -io=mysql,host=localhost,db=foonrip,user=foonrip,password=*****

If you decide to create txt files with foonrip and then import them do the 
following. After creating the txt files first create the table definitions and 
then import the txt files using the following 2 commands:

mysql -u<user> -p -B <databasename> < new-db-def.sql

mysql -u<user> -p -B <databasename> < import-fr-nix.sql

Replace <user> with a MySQL user with write access to <databasename>. You should
do this in the foonrip directory after copying new-db-def.sql and 
import-fr-nix.sql to it.

Windows
=======

First you use FoonRip to create the txt files (info.txt, street.txt, 
subscriber.txt,town.txt,townname.txt).

Then create a database in MySQL and create the tables:

<mysql> -u<user> -p -B <databasename> < new-db-def.sql

Where you replace <mysql> with the path to the mysql client (
c:\mysql\bin\mysql if didn't change the standard install path), <user> with the
user that has the correct acces rights, <databasename> with the name of the
database.

Last but not least copy import-fr-win.sql to your foonrip directory. And run the
 following command:

<mysql> -u<user> -p -B <databasename> < import-fr-win.sql

Don't use the mysqlc client! (in case you definately want to, use import-fr-nix.sql 
instead of import-fr-win.sql)

$Id: import-fr.txt,v 1.4 2002/03/28 10:46:14 EJ Boerwinkel Exp $