Jump to content
The Uniform Server Community

stephanj

Member
  • Content Count

    4
  • Joined

  • Last visited

Community Reputation

0 Neutral

1 Follower

About stephanj

  • Rank
    Newbie
  1. 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
  2. Thanks............... BUT what is the name of the configuration file??
  3. 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??
  4. Hi all I have just downloaded US 3.3 and I must say it looks great. I was just wondering why there isn't' an option to create a table in MySQL using PHPADMIN for a InnoDB storage type? I use InnoDB all the time for my tables in MySQL but, I can't seem to create one using PHPadmin............. Any ideas??
×
×
  • Create New...