Scoutman
05.06.08, 10:07
System ist ein SUES 10 mit MySQL 5. MySQL ist als Dienst installiert und läuft auch problemlos.
Wenn ich MySQL in der Shell aufrufen will funktioniert es leider nicht. Da bekomme ich dann dieses Ergebniss:
>:~ # mysql
mysql: unknown variable 'basedir=/var/lib/mysql'
>:~ #
Die my.cnf Datei sieht so aus:
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
basedir = /var/lib/mysql
tmpdir = /var/lib/mysql/tmp
datadir = /raid_hd/mysql/data
language = /usr/share/mysql/german
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer_size=4000M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size=4000M
net_buffer_length=8
read_buffer_size=5M
read_rnd_buffer_size=512
myisam_sort_buffer_size = 4000M
server-id = 1
# The safe_mysqld script
#Path to the database root
datadir=/raid_hd/mysql/data/
#Path to installation directory. All paths are usually resolved relative to this.
basedir=/var/lib/mysql
#Path to the temporary directory.
tmpdir=/var/lib/mysql/tmp
#If no specific storage engine/table type is defined in an SQL-Create statement the default type will be used.
default-storage-engine=myisam
#Enter a name for the query log file. Otherwise a default name will be used.
log=/var/lib/mysql/log/query.log
#Enter a name for the error log file. Otherwise a default name will be used.
log-error=/var/lib/mysql/log/error.log
#Enter a name for the slow query log. Otherwise a default name will be used.
log-slow-queries=/var/lib/mysql/log/slow_query.log
#Log all queries that have taken more than long_query_time seconds to execute to file.
long_query_time=1
#Log some not critical warnings to the log file.
log-warnings
#Client error messages in given language. May be given as a full path.
language=/usr/share/mysql/german
#Set the default character set.
default-character-set=utf8
#Set the default collation.
default-collation=utf8_unicode_ci
#Enter a name for the binary log. Otherwise a default name will be used.
#log-bin=/var/lib/mysql/log/bin.log
#Tells the master it should log updates for the specified database, and exclude all others not explicitly mentioned.
#binlog-do-db=testrep
#Enter a name for the binary log. Otherwise a default name will be used.
log-bin=
#Tells the master it should log updates for the specified database, and exclude all others not explicitly mentioned.
binlog-do-db=apacheuser
#File that holds the names for last binary log files.
#log-bin-index=/var/lib/mysql/log/bin/bin.index
[safe_mysqld]
err-log=/var/lib/mysql/mysqld.log
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
In den Log Files stehen auch keine Meldungen drinnen die auf irgendetwas hinweisen könnten.
Hat jemand eine Idee?
Wenn ich MySQL in der Shell aufrufen will funktioniert es leider nicht. Da bekomme ich dann dieses Ergebniss:
>:~ # mysql
mysql: unknown variable 'basedir=/var/lib/mysql'
>:~ #
Die my.cnf Datei sieht so aus:
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
basedir = /var/lib/mysql
tmpdir = /var/lib/mysql/tmp
datadir = /raid_hd/mysql/data
language = /usr/share/mysql/german
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer_size=4000M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size=4000M
net_buffer_length=8
read_buffer_size=5M
read_rnd_buffer_size=512
myisam_sort_buffer_size = 4000M
server-id = 1
# The safe_mysqld script
#Path to the database root
datadir=/raid_hd/mysql/data/
#Path to installation directory. All paths are usually resolved relative to this.
basedir=/var/lib/mysql
#Path to the temporary directory.
tmpdir=/var/lib/mysql/tmp
#If no specific storage engine/table type is defined in an SQL-Create statement the default type will be used.
default-storage-engine=myisam
#Enter a name for the query log file. Otherwise a default name will be used.
log=/var/lib/mysql/log/query.log
#Enter a name for the error log file. Otherwise a default name will be used.
log-error=/var/lib/mysql/log/error.log
#Enter a name for the slow query log. Otherwise a default name will be used.
log-slow-queries=/var/lib/mysql/log/slow_query.log
#Log all queries that have taken more than long_query_time seconds to execute to file.
long_query_time=1
#Log some not critical warnings to the log file.
log-warnings
#Client error messages in given language. May be given as a full path.
language=/usr/share/mysql/german
#Set the default character set.
default-character-set=utf8
#Set the default collation.
default-collation=utf8_unicode_ci
#Enter a name for the binary log. Otherwise a default name will be used.
#log-bin=/var/lib/mysql/log/bin.log
#Tells the master it should log updates for the specified database, and exclude all others not explicitly mentioned.
#binlog-do-db=testrep
#Enter a name for the binary log. Otherwise a default name will be used.
log-bin=
#Tells the master it should log updates for the specified database, and exclude all others not explicitly mentioned.
binlog-do-db=apacheuser
#File that holds the names for last binary log files.
#log-bin-index=/var/lib/mysql/log/bin/bin.index
[safe_mysqld]
err-log=/var/lib/mysql/mysqld.log
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
In den Log Files stehen auch keine Meldungen drinnen die auf irgendetwas hinweisen könnten.
Hat jemand eine Idee?