[prev in list] [next in list] [prev in thread] [next in thread] 

List:       interchange-users
Subject:    Re: [ic] Changing for Tab-delimited to MySQL database
From:       Carsten Jahnke <carstenjahnke () web ! de>
Date:       2004-08-31 10:09:56
Message-ID: 41344E74.5060903 () web ! de
[Download RAW message or body]

hi,

create an appropriate file for each mysql-table in 
<catroot>/dbconf/mysql/<tablename>.mysql with a content like the 
following to describe the structure of that table:

Database  cms_element  ptc_element.txt __SQLDSN__

ifdef MYSQL_TRANSACTIONS
Database  cms_element  HAS_TRANSACTIONS  1
Database  cms_element  TABLE_TYPE   InnoDB
endif

Database  cms_element  COLUMN_DEF  "element_id=BIGINT(10) NOT NULL 
AUTO_INCREMENT PRIMARY KEY"
Database  cms_element  COLUMN_DEF  "name=VARCHAR(64) DEFAULT NULL"

then you have to tell IC that it should use mysql for that catalog. I 
think it was

ifndef SQLDSN
Variable  SQLDSN  dbi:mysql:<DATABASENAME>
endif

in <catroot>/catalog.cfg

restart IC then...

according to this and your other questions:
check out http://www.icdevgroup.org/interchange-doc-5.2.0/index.html ;-)

greetings
\cj

Mohamad M. Hodroj wrote:
> Hello, 
> 
> I would like to know if there is a really easy way to change my database
> from Tab-delimited to MySQL...
> 
> Thanks a lot for any help..
> 
> Mohamad
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users

-- 
Carsten Jahnke

email: carstenjahnke@web.de
_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users
[prev in list] [next in list] [prev in thread] [next in thread]