InnoDB Support with Uniform Server??

[stephanj]

Hi all,

 

Great product. I can't seem to get InnoDB support with Uniform Server 3.3 (I am using XP). For example, When I create a script below:

 

CREATE TABLE prime_minister

(

pm_name varchar(12) NOT NULL PRIMARY KEY,

birth_yr smallint NOT NULL,

yrs_served numeric(7,2) NULL,

death_age smallint,

state_born varchar(3) NULL,

state_rep varchar(3) NOT NULL

 

)TYPE=InnoDB;

 

CREATE TABLE pm_recreation

(

pm_name varchar(12) NOT NULL ,

recreation varchar(15) NOT NULL ,

PRIMARY KEY(recreation,pm_name),

INDEX(pm_name),

CONSTRAINT pm_name_fk FOREIGN KEY (pm_name) REFERENCES prime_minister(pm_name)

)TYPE=InnoDB;

 

Uniform server DOES NOT allow InnoDB support. The table defaults automatically to MyISAM.

 

You don't have the option to create InnoDB via PHP admin.

 

Is there a problem with Uniform Server and InnoDB??

[olajideolaolorun]

You may have to tweak the MYSQL Configuration File in the /usr/local/mysql/bin/ folder.

[stephanj]

You may have to tweak the MYSQL Configuration File in the /usr/local/mysql/bin/ folder.

2570[/snapback]

 

 

Thanks............... BUT what is the name of the configuration file??

[stephanj]

Thanks...............  BUT what is the name of the configuration file??

2581[/snapback]

 

 

I HAVE FOUND IT the file W:\usr\local\mysql\bin\my-small is the configuration file

 

I edited as follows (NOTE the comments) to enable InnoDB and it works

 

Thanks so much for a great product!!

 

# Uncomment the following if you are NOT using BDB tables

#skip-bdb

 

# 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

[olajideolaolorun]

Can you help us post this into our wiki?

 

http://wiki.uniformserver.com/Installing_InnoDB

[alvaro]

Hi mates:

 

I have tried the same solution as stephanj, but is not working in my case (Windows XP, Uniserver 3.3). What might I am doing wrong?

 

Please, setephan, could you confirm if that solution worked for you?

[olajideolaolorun]

hmm, please check once more to make sure everything is set correctly. Make sure you do not have another MySQL running in the background...

[alvaro]

That's true. I have been trying to enable INNODB but I had not luck. In the log file it reported that there was a problem with the size of the file ibdata1. So I have deleted these files (ibdata1, ib_logfile1, ib_logfile0) and let MySQL to rebuild it. And voilá. INNODB is enabled in my Uniform Server.

 

Thanks guys. Uniform Server Rocks!

[olajideolaolorun]

Thanks.