You can find which my.cnf your server is reading by using :
mysql --help
which displays something like this:
Default options are read from the following files in the given order:
C:\Windows\my.ini C:\Windows\my.cnf C:\my.ini C:\my.cnf D:\Program
Files\MySQL\M
ySQL Server 5.5\my.ini D:\Program Files\MySQL\MySQL Server 5.5\my.cnf
The following groups are read: mysql client
On 11/4/2011 12:41 PM, Satendra wrote:
Hi there,
Could anybody suggest me to understand on which conf file (my.cnf) my
server is readiing. how could I find that?
On Fri, Nov 4, 2011 at 2:28 AM, Claudio Nanni<claudio.na...@gmail.com>wrote:
All the previous hints are correct.
I would also add: the arithmetic is only good for command line settings,
something like:
max_allowed_packet = 16*1024*1024
is not valid in the my.cnf
max_allowed_packet = 16M
is the way to go in the my.cnf
Cheers
Claudio
2011/11/3 Michael Dykman<mdyk...@gmail.com>
If you changed the value in the .cnf and restarting the server did not
pick
up he change, I would hazard a guess that the .cnf file you edited is not
the one your server is reading.
Check your paths and make sure you are editing the correct file. MySL
never rewrites it's own config files to reflect manually changed values.
On Thu, Nov 3, 2011 at 4:37 PM, List Man<list....@bluejeantime.com>
wrote:
I am running Server version: 5.1.45-log MySQL Community Server (GPL)
and
I
attempted to change max packet with the following: SET GLOBAL
max_allowed_packet=16*1024*1024; but it did not work properly. The
configuration did not change by using the show variables command. I
changed the configuration file (my.cnf) and restarted the server and
the
variable stayed the same. Does anyone have any ideas?
LS
--
- michael dykman
- mdyk...@gmail.com
May the Source be with you.
--
Claudio
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
