[issue]

I'm trying to modify a my.cnf value on my production server but the changes aren't taking effect after a sudo service mysql restart, using an exact copy of the my.cnf (downloaded and replaced original) on my development server the changes made are visible from show variables in mysql commandline.

my.cnf is located at /etc/mysql/my.cnf

sudo find / -name my.cnf
/etc/mysql/my.cnf

So only one file exists on the entire system..

Production is ubuntu 10.04 LTS 64bit
Development is ubuntu 11.10 32bit

Mysql versions are 5.1.61 & 5.1.62 respectively.

Kind Regards,

[my.cnf]

yes it seems to have had all the comments removed and replaced with whitespace.

[client]
port        = 3306
socket      = /var/run/mysqld/mysqld.sock









[mysqld_safe]
socket      = /var/run/mysqld/mysqld.sock
nice        = 0

[mysqld]



















user        = mysql
socket      = /var/run/mysqld/mysqld.sock
port        = 3306
basedir     = /usr
datadir     = /var/lib/mysql
tmpdir      = /tmp
skip-external-locking






bind-address        = 127.0.0.1






key_buffer      = 16M
max_allowed_packet  = 16M
thread_stack        = 192K
thread_cache_size       = 8




myisam-recover         = BACKUP












query_cache_limit   = 1M
query_cache_size        = 16M

















log_error                = /var/log/mysql/error.log





















expire_logs_days    = 10
max_binlog_size         = 100M
innodb_file_per_table = 1







































[mysqldump]
quick
quote-names
max_allowed_packet  = 16M

[mysql]



[isamchk]
key_buffer      = 16M









!includedir /etc/mysql/conf.d/