List:General Discussion« Previous MessageNext Message »
From:Prasanna Raj Date:April 24 2006 11:42am
Subject:Re: Fulltext 3 letter words
View as plain text  
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" <taco.fleur@stripped> 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:Prasad_Mani@stripped] 
> Sent: Monday, 24 April 2006 1:51 PM
> To: taco.fleur@stripped
> 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" <taco.fleur@stripped>
> To: "'Prasad'" <Prasad_Mani@stripped>
> 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:Prasad_Mani@stripped]
> > Sent: Monday, 24 April 2006 1:32 PM
> > To: taco.fleur@stripped
> > 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" <taco.fleur@stripped>
> > To: "'John Hicks'" <johnlist@stripped>;
> <mysql@stripped>
> > 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:johnlist@stripped]
> >> Sent: Monday, 24 April 2006 12:46 PM
> >> To: taco.fleur@stripped
> >> Cc: mysql@stripped
> >> 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:johnlist@stripped]  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/mysql?unsub=1
> >>
> >
> > ********** 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 admin@stripped
> >
> > 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
> >
> >
> > 
> 
> 
> 
> 
Thread
Fulltext 3 letter wordsTaco Fleur24 Apr
  • Re: Fulltext 3 letter wordsJohn Hicks24 Apr
RE: Fulltext 3 letter wordsTaco Fleur24 Apr
  • Re: Fulltext 3 letter wordsJohn Hicks24 Apr
RE: Fulltext 3 letter wordsTaco Fleur24 Apr
RE: Fulltext 3 letter wordsTaco Fleur24 Apr
  • Re: Fulltext 3 letter wordsPrasanna Raj24 Apr
    • Re: Fulltext 3 letter wordsJames Harvard24 Apr
RE: Fulltext 3 letter wordsTaco Fleur25 Apr