Toon posts:

[mysql] probleem met innoDB

Pagina: 1
Acties:
  • 33 views sinds 30-01-2008

Verwijderd

Topicstarter
Op mijn lanserver draait slackware 8.0 met mysql-3.23.51 apache/php/......

nu wou ik gisteren innoDB activeren door dit in de my.cnf file aan te passen

als ik nu mijn myslq server starten krijg ik meteen:
mysql ended

de error log file bevat dit:
code:
1
2
3
4
5
020625 20:57:47  mysqld started
/usr/libexec/mysqld: unrecognized option `--innodb_data_home_dir=/var/lib/mysql/'
/usr/libexec/mysqld  Ver 3.23.51 for slackware-linux-gnu on i386
Copyright (C) 2000 MySQL AB, by Monty and others
.....

nu heb ik al op het net zitten zoeken maar ik kan niets vinden over mn probleem :(

hieronder nog even mn my.cnf file


hopelijk kan iemand me helpen met mijn probleem :'(
code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
# The following options will be passed to all MySQL clients
[client]
#password    = your_password
port        = 3306
socket      = /tmp/mysql.sock
# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port        = 3306
socket      = /tmp/mysql.sock
skip-locking
set-variable    = key_buffer=16M
set-variable    = max_allowed_packet=1M
set-variable    = table_cache=64
set-variable    = sort_buffer=512K
set-variable    = net_buffer_length=8K
set-variable    = myisam_sort_buffer_size=8M
log-bin
server-id    = 1

# Point the following paths to different dedicated disks
tmpdir      = /tmp/
log-update  = /var/log/

# Uncomment the following if you are using BDB tables
#set-variable   = bdb_cache_size=4M
#set-variable   = bdb_max_lock=10000

# Uncomment the following if you are using Innobase tables
innodb_data_file_path = ibdata1:400M
innodb_data_home_dir = /mysql/
innodb_log_group_home_dir = /mysql/
innodb_log_arch_dir = /mysql/
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=4M
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=4M
set-variable = innodb_additional_mem_pool_size=1M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
set-variable    = max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
set-variable    = key_buffer=20M
set-variable    = sort_buffer=20M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

[myisamchk]
set-variable    = key_buffer=20M
set-variable    = sort_buffer=20M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

[mysqlhotcopy]
interactive-timeout

  • whoami
  • Registratie: December 2000
  • Laatst online: 04-09 22:16
Dit heeft volgens mij niets met Programming of Webscripting te maken.
Het is niet omdat het over MySQL gaat, dat het daarom direct over ontwikkeling gaat :)

Ik denk dat je beter af zou zijn bij Software Algemeen.

https://fgheysels.github.io/


Dit topic is gesloten.