How do I enable InnoDB and InnoDB tables in my database ?
I get this error when running IP.Board's self-diagnostics, claiming 'non-InnoDB tables'.
I checked /etc/mysql/my.cnf and it contains the InnoDB directives (see below), but the diagnostics keep claiming 'non-InnoDB tables'.
I must be missing something (obviously). Can someone help, please?
# * InnoDB
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
default_storage_engine = InnoDB
# you can't just change log file size, requires special procedure
innodb_log_file_size = 299M
innodb_buffer_pool_size = 2393M
innodb_log_buffer_size = 598M
innodb_file_per_table = 1
innodb_open_files = 500000
innodb_io_capacity = 500000
innodb_flush_method = O_DIRECT