[ic] How do you change the default Database to use SQL database

[Philip S. Hempel]

On Sat, 2003-05-24 at 20:40, Vincent Lee wrote:
> How do you change the default database of GDBM to use MySQL or some other
> RDBMS?
> 
> Also, how do the *.sql files need to be created..should these include the
> same metadata information as *.txt?
> 
If you downloaded the source, you should have the foundation demo. In
the demo is a directory called dbconf. Each type of support for
different DBM's are shown. For instance, the mysql has all the files
that are used to create the sql calles to create the database.

Also in the demo is a file called catalog.cfg. In it it has by default a
few params related to things like mysql and so on, these point to the
default config for each DBM.
In the products directory there is a file called variables.txt. This
file also contains related information about what database you are
using. Each database config is a part of the Database configuration,
"grep Database variables.txt", this will show you what fields are
present and set for databases. 

Once you have configured each of these areas, and setting the password
and username for the database, placing a 1 in the appropriate DBM, i.e.
Mysql 1 Dataase. Restart interchange and it will drop any tables that
exists with the same name and populate them with the txt files that are
in the products directory. 

That should give you enough to go from there.

Just use the demo as a starting point to get, look at all the pre-filled
data in the text files. Just remember, IC expects, IIRC, all files to be
tab delimited. NO SPACES or the field data will fail.

Read some more on installing interchange on the icdevgroup.org website.
It is on the main page.

Later.


-- 
Philip S. Hempel

Give a man a fish and he will feed himself for a day.
Teach a man to fish and he will feed himself for a lifetime.

http://linuxhardcore.com/