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]
