Network Solution for Windows – Windows system, Linux system, Ubuntu server configuration tip

1).How to enable InnoDB engine?

1. Shutdown the servers.
2. Got to folder: \Server\usr\local\mysql\bin
3. Open the file my-small in a text editor, change the section for innodb to look like this:

# Uncomment the following if you are NOT using innodb tables
#skip-innodb

# Uncomment the following if you are using Innobase tables
innodb_data_file_path = ibdata1:100M
innodb_data_home_dir = /usr/local/mysql/data/
innodb_log_group_home_dir = /usr/local/mysql/data/
innodb_log_arch_dir = /usr/local/mysql/data/
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=8M
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=16M
set-variable = innodb_additional_mem_pool_size=2M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50

Re-start the servers, run phpMyAdmin, click on databases, click on the Engines tab and you should see InnoDB listed click on it, look for Buffer pool size 16,384 KiB, this confirms it is enabled (Uniform Server value) Note: If you still see “InnoDB has been disabled for this MySQL server.” ignore it.

While still in phpMyAdmin click databases, in the Create new database text box type gallery2 and click create. (Assumes you have not already done this), Now have another go at installing gallery2.

2). Is there a way to use gallery2 with MyISAM?

If that fails you can always use MyISAM database engine.
At step 5 of the gallery2 install wizard, from the select database drop down menu select MySQL version before v.3.23.34a .