I think you are using .ini files present in the source directory . Can you copy the .ini file to your datadir ( eg : my-innodb-heavy-4G.ini conf file for 4GB RAM ) and pt out the same at startup ?
Not sure whether iam in the right path .. Correct me if iam wrong --Praj On Mon, 24 Apr 2006 13:59:27 +1000 "Taco Fleur" <[EMAIL PROTECTED]> wrote: > Hi Prasad, > > I have no my.cfn, I have a my.ini which is located at in the same directory > as the my-innodb-heavy-4G.ini > C:\Program Files\MySQL\MySQL Server 5.0 > > > Kind regards, > > Taco Fleur (Mobile 0421 851 786) > > Commerce Engine Pty Ltd - Australia's leading online Payment Gateway . > Local Call 1300 859 179 > Postal Address: PO Box 15118, City East Brisbane, Queensland, 4002, > Australia > Head office: 31 Valencia Court, Eatons Hill, Queensland, 4037, Australia > Telephone: +61 (0) 7 3857 3881 > Fax: +61 (0) 7 3414 6464 > Internet: http://www.commerceengine.com.au > > * Accepting payments online is easy > > * Developer API, XML, POST > > * Low fees > > * Full integration by a one-stop-shop > > ________________________________ > > The information contained in this email may be confidential. You should only > disclose, re-transmit, copy, distribute, act in reliance on or commercialise > the information if you are authorised to do so. Any views expressed in this > email communication are those of the individual sender, except where the > sender specifically states them to be the views of Commerce Engine Pty Ltd. > Any advice contained in this e-mail has been prepared without taking into > account your objectives, financial situation or needs. Before acting on any > advice in this e-mail, Commerce Engine recommends that you consider whether > it is appropriate for your circumstances. Commerce Engine does not > represent, warrant or guarantee that the integrity of this communication has > been maintained nor that the communication is free of errors, virus or > interference. > Commerce Engine Pty Ltd ACN 118 850 552 > > > -----Original Message----- > From: Prasad [mailto:[EMAIL PROTECTED] > Sent: Monday, 24 April 2006 1:51 PM > To: [EMAIL PROTECTED] > Subject: Re: Fulltext 3 letter words > > Hi Taco Fleur., > > Where is your current my.cnf file present? > have it in c:\my.cnf or you have to mention where your file present in the > startup with --defaults-file=path/my.cnf.Note even without cnf file also > mysql can be started. > > -Prasad. > Sify. > > ----- Original Message ----- > From: "Taco Fleur" <[EMAIL PROTECTED]> > To: "'Prasad'" <[EMAIL PROTECTED]> > Sent: Monday, April 24, 2006 9:10 AM > Subject: RE: Fulltext 3 letter words > > > > Sorry I am on OS Windows 2003 > > > > > > Kind regards, > > > > Taco Fleur (Mobile 0421 851 786) > > > > Commerce Engine Pty Ltd - Australia's leading online Payment Gateway . > > Local Call 1300 859 179 > > Postal Address: PO Box 15118, City East Brisbane, Queensland, 4002, > > Australia > > Head office: 31 Valencia Court, Eatons Hill, Queensland, 4037, Australia > > Telephone: +61 (0) 7 3857 3881 > > Fax: +61 (0) 7 3414 6464 > > Internet: http://www.commerceengine.com.au > > > > * Accepting payments online is easy > > > > * Developer API, XML, POST > > > > * Low fees > > > > * Full integration by a one-stop-shop > > > > ________________________________ > > > > The information contained in this email may be confidential. You should > > only > > disclose, re-transmit, copy, distribute, act in reliance on or > > commercialise > > the information if you are authorised to do so. Any views expressed in > > this > > email communication are those of the individual sender, except where the > > sender specifically states them to be the views of Commerce Engine Pty > > Ltd. > > Any advice contained in this e-mail has been prepared without taking into > > account your objectives, financial situation or needs. Before acting on > > any > > advice in this e-mail, Commerce Engine recommends that you consider > > whether > > it is appropriate for your circumstances. Commerce Engine does not > > represent, warrant or guarantee that the integrity of this communication > > has > > been maintained nor that the communication is free of errors, virus or > > interference. > > Commerce Engine Pty Ltd ACN 118 850 552 > > > > > > -----Original Message----- > > From: Prasad [mailto:[EMAIL PROTECTED] > > Sent: Monday, 24 April 2006 1:32 PM > > To: [EMAIL PROTECTED] > > Subject: Re: Fulltext 3 letter words > > > > Hi., > > > > Are you using unix flavor? If so do you have a file my.cnf under /etc. If > > not so copy the file from /mysqlhomepath/support-file/my-huge.cnf to > > /etc/my.cnf Modify the changes in /etc/my.cnf under [mysqld] Innodb tables > > dosent support fulltext index type. You can gothrough the below link where > > you can find full-text search functions. > > http://dev.mysql.com/doc/refman/4.1/en/fulltext-search.html > > > > -Prasad. > > Sify. > > > > ----- Original Message ----- > > From: "Taco Fleur" <[EMAIL PROTECTED]> > > To: "'John Hicks'" <[EMAIL PROTECTED]>; <mysql@lists.mysql.com> > > Sent: Monday, April 24, 2006 8:22 AM > > Subject: RE: Fulltext 3 letter words > > > > > >> > >> In "my-innodb-heavy-4G.ini" I modified the following line ft_min_word_len > >> = > >> 3 > >> There are a couple of .ini files in the same directory I just modified > >> the > >> one that actually had the occurrence of "ft_min_word_len" in it. > >> > >> Kind regards, > >> > >> Taco Fleur > >> > >> Commerce Engine Pty Ltd - Australia's leading online Payment Gateway . > >> Local Call 1300 859 179 > >> Postal Address: PO Box 15118, City East Brisbane, Queensland, 4002, > >> Australia > >> Head office: 31 Valencia Court, Eatons Hill, Queensland, 4037, Australia > >> Telephone: +61 (0) 7 3857 3881 > >> Fax: +61 (0) 7 3414 6464 > >> Internet: http://www.commerceengine.com.au > >> > >> * Accepting payments online is easy > >> > >> * Developer API, XML, POST > >> > >> * Low fees > >> > >> * Full integration by a one-stop-shop > >> > >> ________________________________ > >> > >> The information contained in this email may be confidential. You should > >> only > >> disclose, re-transmit, copy, distribute, act in reliance on or > >> commercialise > >> the information if you are authorised to do so. Any views expressed in > >> this > >> email communication are those of the individual sender, except where the > >> sender specifically states them to be the views of Commerce Engine Pty > >> Ltd. > >> Any advice contained in this e-mail has been prepared without taking into > >> account your objectives, financial situation or needs. Before acting on > >> any > >> advice in this e-mail, Commerce Engine recommends that you consider > >> whether > >> it is appropriate for your circumstances. Commerce Engine does not > >> represent, warrant or guarantee that the integrity of this communication > >> has > >> been maintained nor that the communication is free of errors, virus or > >> interference. > >> Commerce Engine Pty Ltd ACN 118 850 552 > >> > >> > >> -----Original Message----- > >> From: John Hicks [mailto:[EMAIL PROTECTED] > >> Sent: Monday, 24 April 2006 12:46 PM > >> To: [EMAIL PROTECTED] > >> Cc: mysql@lists.mysql.com > >> Subject: Re: Fulltext 3 letter words > >> > >>> > >>> Taco Fleur wrote: > >>>> Hi all, > >>>> > >>>> I know I asked this question before and I do apologise for having to > >>>> ask again, but I have not been able to get this to work for us. > >>>> I modified the config file (there were many in the folder, not sure > >>>> whether I modified the right one) restarted the whole machine since > >>>> then, but it still won't pick up the change I made. When I look at > >>>> the values of the variables it still shows the old value, I must be > >>>> missing > >>> something. > >>>> Would someone be so kind to give me a quick step by step run down > >>>> again on what to do to be able to have fulltext work with 3 letter > >>>> words? Thanks in advance. > >> > >>>From: John Hicks [mailto:[EMAIL PROTECTED] What version of > >>>MySQL are you running? The ability to specify the minimum length for > >>>fulltext search was not always supported. > >> > >> Taco Fleur wrote: > >>> Hi, that would be version 5.0.18 - thanks > >> > >> Then your version is not the problem. > >> > >> What specifically did you change in your cfg file? > >> > >> --John > >> > >> > >> > >> -- > >> MySQL General Mailing List > >> For list archives: http://lists.mysql.com/mysql > >> To unsubscribe: > >> http://lists.mysql.com/[EMAIL PROTECTED] > >> > > > > ********** DISCLAIMER ********** > > Information contained and transmitted by this E-MAIL is proprietary to > > Sify Limited and is intended for use only by the individual or entity to > > which it is addressed, and may contain information that is privileged, > > confidential or exempt from disclosure under applicable law. If this is a > > forwarded message, the content of this E-MAIL may not have been sent with > > the authority of the Company. If you are not the intended recipient, an > > agent of the intended recipient or a person responsible for delivering > > the > > information to the named recipient, you are notified that any use, > > distribution, transmission, printing, copying or dissemination of this > > information in any way or in any manner is strictly prohibited. If you > > have > > received this communication in error, please delete this mail & notify us > > immediately at [EMAIL PROTECTED] > > > > Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click > > Here. www.sifymax.com > > > > Get to see what's happening in your favourite City on Bangalore Live! > > www.bangalorelive.in > > > > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]