Do you mean this page <http://dev.mysql.com/doc/mysql/en/Option_files.html>?
Michael
[EMAIL PROTECTED] wrote:
Could it be that you have put your variables into the wrong section of your configuration file? I haven't been able to look it up to verify my information but I thought the section that starts with [mysql] contained settings for the command line client while the section that starts with [mysqld] contains settings for the server.
I would love to have the link(s) into the manual for the page(s) that describes which section header to use in the INI/CFG file for which product (mysql, mysqld, mysqldump, etc). I know I read it somewhere (a long time ago) but I can't find it today. Thanks!
Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Hariett Jones <[EMAIL PROTECTED]> wrote on 11/15/2004 06:42:31 AM:
I want to set some variables once and for all. How should i do it ?
I need following vars to be set :
character_set_client=latin2 character_set_connection=latin2 character_set_database=latin2 character_set_results=latin2 character_set_server=latin2 character_set_system=latin2 collation_connection=latin2_bin collation_database=latin2_bin collation_server=latin2_bin
i have put them into /etc/my.cnf ,but it does not work.
[mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates character_set_client=latin2 character_set_connection=latin2 character_set_database=latin2 character_set_results=latin2 character_set_server=latin2 character_set_system=latin2 collation_connection=latin2_bin collation_database=latin2_bin collation_server=latin2_bin
The variables appear to be : variable session value global value
character set client latin1 latin2
character set connection latin1 latin2
character set database latin2 latin2
character set results latin1 latin2
character set server latin2 latin2
character set system utf8 utf8
character sets dir /usr/local/mysql/share/mysql/charsets/ /usr/local/mysql/share/mysql/charsets/
collation connection latin1_swedish_ci latin2_general_ci
collation database latin2_general_ci latin2_general_ci
collation server latin2_general_ci latin2_general_ci
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
