[ic] Upgrading to SQL Database

Brian Kosick interchange-users@icdevgroup.org
Wed Sep 25 11:01:03 2002


This is absolutely correct, the dbconf file quite often do not reflect the 
changes made in the gdbm/flat files, before you try to switch over to SQL, 
make sure that all the dbconf files are setup correctly...


At 03:33 PM 9/24/02 -0700, you wrote:
>At 05:49 PM 9/24/2002 -0400, you wrote:
>>We currently run a catalog using the default (flat file) database for 
>>IC.  Does anyone know of any documentation on how to upgrade to a SQL 
>>database for an existing catalog?
>
>That would make a nice little FAQ addition.  For me, I just add "MYSQL 1" 
>and "SQL_DSN ..." variables to my configuration, restart, and IC does all 
>the rest.  Some people have more trouble, so it would be nice for someone 
>to write up a neat little FAQ on it (any takers?).
>
>>While on that topic, what is IC more finely tuned for?  mySQL or Postgres 
>>or another DB?  Suggestions (no war please) would be appreciated.
>
>MySQL and PostgreSQL both work rather well, I recommend that you use 
>whichever you are most comfortable with.
>
>--
>/~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\
>| Dan Browning, Kavod Technologies      <dan.browning@kavod.com> |
>| (360) 882-7872 x7, 6700 NE 162nd Ave, Suite 210, Vancouver, WA |
>\~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~/
>"Even the best of friends cannot attend each other's funeral."
>                 -- Kehlog Albran, "The Profit"
>
>_______________________________________________
>interchange-users mailing list
>interchange-users@icdevgroup.org
>http://www.icdevgroup.org/mailman/listinfo/interchange-users

Brian Kosick
Web Programmer
New Age Consulting Service, Inc.
216-619-2000
briank@nacs.net