[Bug 604093] New: mysql option "datadir" cannot be defined in /etc/my.cnf
http://bugzilla.novell.com/show_bug.cgi?id=604093 http://bugzilla.novell.com/show_bug.cgi?id=604093#c0 Summary: mysql option "datadir" cannot be defined in /etc/my.cnf Classification: openSUSE Product: openSUSE 11.2 Version: Final Platform: x86-64 OS/Version: openSUSE 11.2 Status: NEW Severity: Normal Priority: P5 - None Component: Other AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: novell-web@zmi.at QAContact: qa@suse.de Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; de; rv:1.9.2.3) Gecko/20100401 SUSE/3.6.3-1.2 Firefox/3.6.3 It is there uncommented: # grep datadir /etc/my.cnf #datadir = /var/lib/mysql/ and I uncommented it but then mysql doesn't start. You can't also use mysqldump anymore: mysqldump: unknown variable 'datadir=/var/lib/mysql/databases' I had to change /etc/init.d/mysql to define datadir to another that the default place. According to the mysql docs at http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_d... it should work, so where is the error? Reproducible: Always Steps to Reproduce: 1. uncomment /etc/my.cnf value "datadir = " 2. restart mysql (doesn't work) 3. try mysqldump (doesn't work) Actual Results: crash Expected Results: should work -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=604093 http://bugzilla.novell.com/show_bug.cgi?id=604093#c yang xiaoyu <xyyang@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |xyyang@novell.com AssignedTo|bnc-team-screening@forge.pr |mhrusecky@novell.com |ovo.novell.com | -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=604093 http://bugzilla.novell.com/show_bug.cgi?id=604093#c1 Michal Hrusecky <mhrusecky@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 - None |P4 - Low Status|NEW |NEEDINFO InfoProvider| |novell-web@zmi.at --- Comment #1 from Michal Hrusecky <mhrusecky@novell.com> 2010-05-10 13:08:44 UTC --- Works for me... Just tried that on clean 11.2. Your grep would suggest that you have it commented out instead of using it actually, but your error sugests that it is being used... In which section do you have it? I think it is even uncommented by default... What is the name of the datadir you are trying to specify? Can you share output of 'my_print_defaults mysqld'? -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=604093 http://bugzilla.novell.com/show_bug.cgi?id=604093#c2 Michael Monnerie <novell-web@zmi.at> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW CC| |novell-web@zmi.at InfoProvider|novell-web@zmi.at | --- Comment #2 from Michael Monnerie <novell-web@zmi.at> 2010-05-10 21:05:39 UTC --- Sorry for the confusion. I have a my.cnf that was provided by the rpm, this is the first section: [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # Change following line if you want to store your database elsewhere #datadir = /var/lib/mysql/ But when I change this to: datadir = /var/lib/mysql/databases I get errors. Now I have this value commented out, and modified /etc/init.d/mysql instead to have datadir=/var/lib/mysql/databases around line 522. The define was there, it was datadir=/var/lib/mysql and I just hadd to add "/databases" to the end. mfg zmi -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=604093 http://bugzilla.novell.com/show_bug.cgi?id=604093#c3 --- Comment #3 from Michael Monnerie <novell-web@zmi.at> 2010-05-10 21:06:52 UTC --- # my_print_defaults mysqld --port=3306 --socket=/var/lib/mysql/mysql.sock --skip-locking --key_buffer_size=222M --max_allowed_packet=16M --table_open_cache=1024 --sort_buffer_size=16M --net_buffer_length=8K --read_buffer_size=1M --read_rnd_buffer_size=1M --myisam_sort_buffer_size=1M --thread_concurrency=3 --tmp_table_size=64M --query_cache_size=64M --server-id=1 --tmpdir=/var/lib/mysql/mysql-tmp --log-bin=/var/lib/mysql/mysql-bin/bin --expire_logs_days=7 --innodb_file_per_table --innodb_data_home_dir=/var/lib/mysql/innodb --innodb_data_file_path=ibdata1:32M:autoextend --innodb_log_group_home_dir=/var/lib/mysql/innodb-logs --innodb_buffer_pool_size=500M --innodb_additional_mem_pool_size=8M --innodb_log_file_size=150M --innodb_log_buffer_size=32M --innodb_flush_log_at_trx_commit=1 --innodb_lock_wait_timeout=50 --max_connections=500 -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=604093 http://bugzilla.novell.com/show_bug.cgi?id=604093#c4 --- Comment #4 from Michal Hrusecky <mhrusecky@novell.com> 2010-05-18 11:52:10 UTC --- datadir = /var/lib/mysql/ should be in mysqld section of your my.cnf - after [mysqld] and not after [client] section. That would explain the errors and missing functionality. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=604093 https://bugzilla.novell.com/show_bug.cgi?id=604093#c5 Michael Monnerie <novell-web@zmi.at> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED --- Comment #5 from Michael Monnerie <novell-web@zmi.at> 2012-02-16 07:25:18 UTC --- Thanks. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
participants (1)
-
bugzilla_noreply＠novell.com