[ic] SQl Database Setup

[Ed LaFrance]

At 02:50 PM 09/11/2001 +0100, you wrote:
>Hi list,
>
>what is the easiest way to change from the standard interchange database 
>to mysql ?
>Mysql was set up o.k. and a catalog is running under it already.
>There is only one catalog which needs to be changed to Mysql.
>There is something over 20.000 articles in the products.txt. which should 
>qualify the catalog for Mysql.
>
>I suppose its not just changing the catalog.cfg, or ist it ?

Basically.  Depending upon what IC version you are running, I think all you 
need to do is edit /CATROOT/dbconf/mysql/mysql.cfg to provide the database 
name, username and password, then set the catalog variables SOMESQL and 
MYSQL to '1'.  When you restart it will try to build the tables.

- Ed L.



>Lets pretend it is that easy, do we have to change interchange tags, can 
>we still use the regular search and
>list functions ... (got used to use !) or do we have to use all new sql 
>commands (oh no!) ?
>
>
>Vielen Dank
>
>
>JoE
>
>US Video Center Medien GmbH
>Heimsheimer Str 22
>70499 Stuttgart
>
>Tel 0711 880252 0
>Fax 0711 880252 22
>Email joachim.richter@usvideocenter.de
>
>_______________________________________________
>interchange-users mailing list
>interchange-users@interchange.redhat.com
>http://interchange.redhat.com/mailman/listinfo/interchange-users

===============================================================
New Media E.M.S.               Software Solutions for Business
463 Main St., Suite D          eCommerce | Consulting | Hosting
Placerville, CA  95667         edl@newmediaems.com
(530) 622-9421                 http://www.newmediaems.com
(866) 519-4680 Toll-Free       (530) 622-9426 Fax
===============================================================