stephanj Posted February 16, 2006 Report Share Posted February 16, 2006 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?? Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted February 17, 2006 Report Share Posted February 17, 2006 You may have to tweak the MYSQL Configuration File in the /usr/local/mysql/bin/ folder. Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
stephanj Posted February 17, 2006 Author Report Share Posted February 17, 2006 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?? Quote Link to comment Share on other sites More sharing options...
stephanj Posted February 17, 2006 Author Report Share Posted February 17, 2006 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 tablesinnodb_data_file_path = ibdata1:100Minnodb_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=1set-variable = innodb_log_files_in_group=3set-variable = innodb_log_file_size=5Mset-variable = innodb_log_buffer_size=8Minnodb_flush_log_at_trx_commit=1innodb_log_archive=0set-variable = innodb_buffer_pool_size=16Mset-variable = innodb_additional_mem_pool_size=2Mset-variable = innodb_file_io_threads=4set-variable = innodb_lock_wait_timeout=50 Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted March 2, 2006 Report Share Posted March 2, 2006 Can you help us post this into our wiki? http://wiki.uniformserver.com/Installing_InnoDB Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
alvaro Posted April 27, 2006 Report Share Posted April 27, 2006 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? Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted April 30, 2006 Report Share Posted April 30, 2006 hmm, please check once more to make sure everything is set correctly. Make sure you do not have another MySQL running in the background... Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
alvaro Posted May 6, 2006 Report Share Posted May 6, 2006 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! Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted May 6, 2006 Report Share Posted May 6, 2006 Thanks. Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.