Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a dedicated server which is running MySQL.

In the my.cnf configuration file, I added this configuration a long time ago :

set-variable=local-infile=0

It was working fine, but since yesterday, my server started to act strangely, and after a reboot, I was unable to start mysql.

The probleme was located at this configuration, as stated in the logs :

[ERROR] /usr/sbin/mysqld: unknown variable 'set-variable=local-infile=0'

And after having commented this line, mysql started fine.

Is there something I missed, an update that break this type of configuration ? I'm really wondering what happened.

I run MySQL 5.5.31-0+wheezy1

(Note: I'm aware of this quite similar question, but I'm looking to understand what changed, not where is the problem ;))

Thanks for your help!

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

Remove the set-variable. That is no longer used in the my.cnf

share|improve this answer
    
Do you have an idea about why/since when this configuration is obsolete / abandonned ? –  Cyril N. Dec 16 '13 at 12:18
    
Versioning. MySQL changed how they run their config. –  Jason Pass Dec 16 '13 at 12:25
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.