[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] Upgrading to SQL Database
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