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:
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
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 |