Apache Friends Support Forum

It is currently 21. November 2009 11:31

All times are UTC + 1 hour




Post new topic Reply to topic  [ 7 posts ] 
Author Message
 Post subject: How can you set mysql variables in my.ini
PostPosted: 04. November 2009 03:34 
Offline

Joined: 04. November 2009 03:29
Posts: 3
I'm looking to change the minimum stop words for mysql. This is supposed to be done in my.ini however I change the setting, reset the service and mysql is still reporting the value as 4. Is there some other location I'm supposed to change this other than in the my.ini file in the mysql/bin directory?


Top
 Profile  
 
 Post subject: Re: How can you set mysql variables in my.ini
PostPosted: 04. November 2009 03:56 
Offline
User avatar

Joined: 25. April 2006 17:06
Posts: 3049
Location: Brisbane, Australia Chermside Court Motel and Herston Place Motel
mydarkpassenger wrote:
...I change the setting, reset the service and mysql is still reporting the value as 4...
Try Stopping then Starting MySQL again as I have no idea what you mean by reset the service.


Last edited by Izzy on 04. November 2009 04:08, edited 1 time in total.

Top
 Profile  
 
 Post subject: Re: How can you set mysql variables in my.ini
PostPosted: 04. November 2009 04:07 
Offline

Joined: 04. November 2009 03:29
Posts: 3
I've actually restarted my machine since then and no go.


Top
 Profile  
 
 Post subject: Re: How can you set mysql variables in my.ini
PostPosted: 04. November 2009 04:31 
Offline
User avatar

Joined: 25. April 2006 17:06
Posts: 3049
Location: Brisbane, Australia Chermside Court Motel and Herston Place Motel
Do you have more my.ini files on your PC other than in the mysql\bin folder, perhaps in the Windows folder?

If so then your XAMPP MySQL instance may be reading the wrong my.ini file.


Top
 Profile  
 
 Post subject: Re: How can you set mysql variables in my.ini
PostPosted: 04. November 2009 13:16 
Offline

Joined: 04. November 2009 03:29
Posts: 3
Check my Windows directory and nothing. Is there a way to find out what file xampp is trying to use?


Top
 Profile  
 
 Post subject: Re: How can you set mysql variables in my.ini
PostPosted: 04. November 2009 21:09 
Offline
User avatar

Joined: 25. April 2006 17:06
Posts: 3049
Location: Brisbane, Australia Chermside Court Motel and Herston Place Motel
mydarkpassenger wrote:
...Is there a way to find out what file xampp is trying to use?
Assuming you are using XAMPP 1.7.2 (you have not supplied that detail) in your XAMPP Control Panel (XCP) check if MySQL is running as a Windows NT Service by the tick in the Svc box and the green running indication.

Click on the SCM (Service Control Manager) button.

Look in the list for MySQL.

Right click on the MySQL entry and select Properties

Look for Path to executable, you should see something like this:
"C:\xampp\mysql\bin\mysqld.exe" --defaults-file="C:\xampp\mysql\bin\my.ini" MySQL


Top
 Profile  
 
 Post subject: Re: How can you set mysql variables in my.ini
PostPosted: 05. November 2009 08:21 
Offline
AF-Moderator

Joined: 01. February 2004 12:38
Posts: 16640
Location: Stuttgart / Germany
Quote:
This is supposed to be done in my.ini however I change the setting, reset the service and mysql is still reporting the value as 4.

What exactly have you added to the my.ini. And more important: where in the my.ini have you added this?


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 19 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group