[ic] Using MySQL and GDBM concurrently, how does IC determine which to attempt to access first?

Brian Kosick interchange-users@icdevgroup.org
Fri Sep 13 12:04:00 2002


At 11:14 AM 9/12/02 -0700, you wrote:
>Before I jump off a cliff, now that we're running I'm looking to move the 
>db's from DBM to MySQL, if I enable the MYSQL flag in IC, I need to know 
>the order of precedence in IC.  Specifically, when IC attempts to connect 
>to a table, which will it attempt to find first, the DBM or MySQL and if 
>it fails on the first, will it attempt the second?
>
>I spotted Mark's outline for converting from GDBM to MySQL, but it is 
>rather terse and I'm sure there are pot-holes that could quickly make my 
>life miserable...
>
>Barry
>
>--
>
>Barry Treahy, Jr  *  Midwest Microwave  *  Vice President & CIO
>E-mail: Treahy@mmaz.com * Phone: 480/314-1320 * FAX: 480/661-7028
>
>
>_______________________________________________
>interchange-users mailing list
>interchange-users@icdevgroup.org
>http://www.icdevgroup.org/mailman/listinfo/interchange-users

It's actually quite easy.

1)  Compare the products/*.txt files with the dbconf/mysql/*.mysql files, 
make sure that the fields match up, and the field types are set correctly.

2)  restart interchange.  IC will automagically create the tables from 
dbconf/mysql and import the data from your products/*.txt 
files.  (Note:  If you have products/*.sql or products/*.autonumber for the 
tables that will now be Mysql, you may have to delete them.  Don't worry, 
they'll get recreated.)

3)  If you run into problems, such as IC spitting out an error like 
"products not a database" It usually means that you have errors in 
dbconf/mysql/*.mysql.  Most common problem I've run into is IC trying to 
import text fields into Mysql fields that are too short.  Ex.  importing a 
text file description that is over 255 char long into the Mysql field 
description that is configured to be VARCHAR(255) change it to (TEXT) and 
everything should be fine.

4)  Pat yourself on the back, and pop open a brew...


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