[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:12:00 2002


At 12:03 PM 9/13/02 -0400, you wrote:
>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
>
>_______________________________________________
>interchange-users mailing list
>interchange-users@icdevgroup.org
>http://www.icdevgroup.org/mailman/listinfo/interchange-users


Oops maybe I read this wrong.  If a table is defined as Mysql (located in 
dbconf/mysql), it will use Mysql.  If not it will use GDBM


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