Apache2triad 1.2 - innoDB tables

[Jan]

I am using Apache2triad 1.2 as local development environment. It is
working fine, but I cannot create InnoDB tables with the phpMyAdmin
2.5.6 included in this package.

According to the my.ini file (see below) some lines in this file must
be commented or uncommented to use innoDB. If I do this, the mySQL
server does not start any more.

Thanks for your help
Jan

# Comment the following row if you want touse the InnoDb tables
skip-innodb

# Uncomment the following rows if you are using InnoDB tables
# Create the directories ibdata and iblogs before to start the server.
# If necessary, modify the size of the files

#innodb_log_gro up_home_dir = C:\apache2\mysq l\iblogs
#innodb_data_fi le_path = ibdata1:200M
#innodb_data_ho me_dir = C:\apache2\mysq l\ibdata
#innodb_flush_l og_at_trx_commi t=1
#innodb_log_arc h_dir = C:\apache2\mysq l\iblogs
#innodb_log_arc hive=0
#set-variable = innodb_mirrored _log_groups=1
#set-variable = innodb_log_file s_in_group=3
#set-variable = innodb_log_file _size=30M
#set-variable = innodb_log_buff er_size=8M
#set-variable = innodb_buffer_p ool_size=80M
#set-variable=lower_ case_table_name s =0
#set-variable = innodb_addition al_mem_pool_siz e=10M
#set-variable = innodb_file_io_ threads=4
#set-variable = innodb_lock_wai t_timeout=50

[Jason Ozias]

On 26 Apr 2004 10:14:48 -0700, Jan <wi***@hsu-hh.de> wrote:

The most common reason the server won't start is that the directories
iblogs and ibdata need to be created beforehand. They aren't
automatically created. If that's not the issue check the error
logs...they are usually pretty helpful.

I am using Apache2triad 1.2 as local development environment. It is
working fine, but I cannot create InnoDB tables with the phpMyAdmin
2.5.6 included in this package.

According to the my.ini file (see below) some lines in this file must
be commented or uncommented to use innoDB. If I do this, the mySQL
server does not start any more.

Thanks for your help
Jan

# Comment the following row if you want touse the InnoDb tables
skip-innodb

# Uncomment the following rows if you are using InnoDB tables
# Create the directories ibdata and iblogs before to start the server.
# If necessary, modify the size of the files

#innodb_log_gro up_home_dir = C:\apache2\mysq l\iblogs
#innodb_data_fi le_path = ibdata1:200M
#innodb_data_ho me_dir = C:\apache2\mysq l\ibdata
#innodb_flush_l og_at_trx_commi t=1
#innodb_log_arc h_dir = C:\apache2\mysq l\iblogs
#innodb_log_arc hive=0
#set-variable = innodb_mirrored _log_groups=1
#set-variable = innodb_log_file s_in_group=3
#set-variable = innodb_log_file _size=30M
#set-variable = innodb_log_buff er_size=8M
#set-variable = innodb_buffer_p ool_size=80M
#set-variable=lower_ case_table_name s =0
#set-variable = innodb_addition al_mem_pool_siz e=10M
#set-variable = innodb_file_io_ threads=4
#set-variable = innodb_lock_wai t_timeout=50

[Jason Ozias]

On 26 Apr 2004 10:14:48 -0700, Jan <wi***@hsu-hh.de> wrote:

The most common reason the server won't start is that the directories
iblogs and ibdata need to be created beforehand. They aren't
automatically created. If that's not the issue check the error
logs...they are usually pretty helpful.

I am using Apache2triad 1.2 as local development environment. It is
working fine, but I cannot create InnoDB tables with the phpMyAdmin
2.5.6 included in this package.

According to the my.ini file (see below) some lines in this file must
be commented or uncommented to use innoDB. If I do this, the mySQL
server does not start any more.

Thanks for your help
Jan

# Comment the following row if you want touse the InnoDb tables
skip-innodb

# Uncomment the following rows if you are using InnoDB tables
# Create the directories ibdata and iblogs before to start the server.
# If necessary, modify the size of the files

#innodb_log_gro up_home_dir = C:\apache2\mysq l\iblogs
#innodb_data_fi le_path = ibdata1:200M
#innodb_data_ho me_dir = C:\apache2\mysq l\ibdata
#innodb_flush_l og_at_trx_commi t=1
#innodb_log_arc h_dir = C:\apache2\mysq l\iblogs
#innodb_log_arc hive=0
#set-variable = innodb_mirrored _log_groups=1
#set-variable = innodb_log_file s_in_group=3
#set-variable = innodb_log_file _size=30M
#set-variable = innodb_log_buff er_size=8M
#set-variable = innodb_buffer_p ool_size=80M
#set-variable=lower_ case_table_name s =0
#set-variable = innodb_addition al_mem_pool_siz e=10M
#set-variable = innodb_file_io_ threads=4
#set-variable = innodb_lock_wai t_timeout=50