[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] MYsql?
At 10:02 AM 03/23/2001 -0700, you wrote:
>So I need to make a new catalog in order to switch? It makes sense, I was
>just hoping for a less involved solution. Lazy again :)
NO, you can just edit the catalog.cfg for your existing catalog:
Variable SOMESQL 1
Variable MYSQL 1
#Variable PGSQL
#Variable ORACLE
Variable SQLDSN dbi:mysql:databasename
Variable SQLDB databasename
Variable SQLUSER username
Variable SQLPASS password
Create a database with 'databasename' in mysql and grant all privileges to
username@localhost identified by 'password'. Then make the changes to you
catalog.cfg (like above) and restart interchange. If all goes well you
should see the table creation messages echoed to the screen and the data
will be be imported. You can look in yourcat/dbconf/mysql to see the table
definition files.
You will need to have the proper Perl modules installed before doing any of
this - they are listed in the docs for SQL Support.
- Ed L.
>GL
>
>----- Original Message -----
>From: Jason Kohles <jkohles@redhat.com>
>To: <interchange-users@lists.akopia.com>
>Sent: Friday, March 23, 2001 9:33 AM
>Subject: Re: [ic] MYsql?
>
>
> > On Fri, Mar 23, 2001 at 09:29:46AM -0700, George Loch wrote:
> > > How many folks have taken the construct demo and converted it to a mysql
>DB
> > > instead of the flat file? What is the procedure other than by hand?
> > >
> > It should take nothing more than telling makecat to use mysql when you
>create
> > the catalog, I've always installed it using mysql.
> >
> > --
> > Red Hat E-Business Solutions Jason Kohles
> > 11480 Sunset Hills Road Senior System Architect
> > Reston, VA 20190 jkohles@redhat.com
> >
> > _______________________________________________
> > Interchange-users mailing list
> > Interchange-users@lists.akopia.com
> > http://lists.akopia.com/mailman/listinfo/interchange-users
> >
>
>
>_______________________________________________
>Interchange-users mailing list
>Interchange-users@lists.akopia.com
>http://lists.akopia.com/mailman/listinfo/interchange-users
===============================================================
**** Virtual Hosting w/private IC Installation, $65/month! ****
---------------------------------------------------------------
New Media E.M.S. Software Solutions for Business
463 Main St., Suite D eCommerce | Consulting | Hosting
Placerville, CA 95667 edl@newmediaems.com
(530) 622-9421 http://www.newmediaems.com
(866) 519-4680 Toll-Free (530) 622-9426 Fax
===============================================================
_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users
