I cannot see the InnoDB engine as an option even though the /etc/my.cnf file has the "skip-innodb" liine commented out and the MySQL has been restarted.
Any thoughts? The my.cnf file reads:
Code:
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.
# The following options will be passed to all MySQL clients
[client]
password =XXXXXXXXXXXXXXXXX
port = 3306
user = root
socket = /var/lib/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
datadir = /var/lib/mysql
basedir = /usr/local/mysql
#bind-address =
skip-locking
#skip-innodb
join_buffer_size = 4M
key_buffer_size = 12M
query_cache_limit = 128K
query_cache_size = 2M
query_cache_type = 1
max_allowed_packet = 1M
max_heap_table_size = 8M
read_buffer_size = 2M
record_buffer = 3M
sort_buffer_size = 1M
table_cache = 1024
thread_cache_size = 20
thread_stack = 128K
tmp_table_size = 8M
innodb_file_per_table
innodb_log_file_size = 5M
innodb_log_buffer_size = 1M
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
innodb_thread_concurrency = 4
innodb_buffer_pool_size = 16M
innodb_flush_log_at_trx_commit=1
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
#
skip-networking
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[mysqlhotcopy]
interactive-timeout
[mysql_upgrade]
basedir = /usr/local/mysql
datadir = /var/lib/mysql
Thanks -- Tony