Gilson,
1. Dustin is correct with the cfupdate and cfinsert not working in
Linux. Its a known bug that was supposed be fixed in sp2 (I believe
anyway). Use the standard sql insert and update. When your site gets lots
of traffic, using those two will keep your db happy!
2. Mysql doesn't support transactions. Probably won't for awhile or maybe
never.
Also, I don't know if your have MS Access on hand or not but,
http://www.mysql.com has a odbc tool that converts access to mysql. You'll
have to import your sql data into ms access then odbc to new mysql
db. I've only used it once and it worked well (on a small set of
tables. If your db is robust I might question its ability). I make the
db's by hand in mysql now (it seems faster for me) so I can't tell you
anything anything more than that. Here's the direct
link: http://mysql.com/downloads/api-myodbc.html
Brett
At 12:01 AM 12/29/00 -0700, you wrote:
>Gilson,
>
>I just completed a conversion from NT/MSSQL to Linux/MySql. Couple of
>things to note:
>
>1. As Steve said, filenames are now case sensitive.
>2. CustomTags are searched-for in the same manner as under Windows -- under
>Linux, it MUST be in the CUSTOMTAGS directory.
>3. The MySQL ODBC Driver (by Merant) that ships with CF does NOT SUPPORT
>TRANSACTIONS. Therefore, using CFTRANSACTION will cause an exception.
>4. In MySQL, table names are case sensitive, but everything else is not.
>5. I used @@IDENTIY values in MSSQL, so had to convert those to AUTO
>INCREMENT values in MySQL.
>6. CFINSERT and CFUPDATE do not appear to work with MySQL.
>
>I think those are about the biggest GOTCHAS I have found so far. Now, I'm
>off to stress testing!
>
>-Dustin
>
> >
> > Date: Fri, 29 Dec 2000 00:22:29 -0200
> > From: Gilson Soares <[EMAIL PROTECTED]>
> > To: [EMAIL PROTECTED]
> > Subject: Re: Porting from Win2K to Linux
> > Message-ID: <[EMAIL PROTECTED]>
> >
> > Thanks Steve.
> > I will start the port next week. I will try to record all issues and tell
> > you the results.
> >
> > Happy New Millenium.
> >
> > At 28/12/2000 11:47 -0500, you wrote:
> > >Be careful of your case sensitivity with filenames dealing with
> > >cfinclude/cfmodule, custom tags, Application.cfm and OnRequestEnd.cfm.
> > >Also at the web server level with image case sensitivity. If you're
> > >using Apache, you can try the mod_speling to solve the problem with the
> > >images. The .cfm's you have to do check by hand.
> > >
> > >I'm not sure about the DB2 port, but I imagine that should move over
> > >just fine.
> > >
> > >Steve Nelson
> > >http://www.SecretAgents.com
> > >Tools for Fusebox Developers
> > >(804) 825-6093
> > >
> > >
> > >Gilson Soares wrote:
> > > >
> > > > Hi everybody,
> > > >
> > > > I have a ColdFusion application (around 260 CFM in Fusebox)
> > running ok with
> > > > DB2 on win2k (I personally prefer Linux).
> > > > It's time to deploy it. I just received a server box to try running it
> > > > under Linux, ie CF-Linux and DB2-Linux.
> > > >
> > > > Has anyone made this migration before (even not using DB2) ?
> > > > Has any cautions that I am be aware off?
> > > >
> > > > PS: All Custom Tags I use are strictly CFM. No objects, OCX, C++, etc.
> > > >
> > > > Thanks
> > > > Gilson Soares
> > > >
> > > >
> > >
> >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
