Heikki, I actually upgraded from Max-3.23.51 to the 4.0.2 server. The only way I could get it to start was to comment out all of the innodb variables in the my.cnf file. After it started I noticed that InnoDB was disabled when I typed: show variables like "have_%".
The contents of the my.cnf file: [mysqld] innodb_data_home_dir = / innodb_data_file_path = ibdata/ibdata1:500M set-variable = innodb_buffer_pool_size=32M set-variable = innodb_additional_mem_pool_size=20M innodb_log_group_home_dir = /var/lib/mysql innodb_log_arch_dir = /var/lib/mysql innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=16M set-variable = innodb_log_buffer_size=2M innodb_flush_log_at_trx_commit=1 set-variable = max_connections=20 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 set-variable = record_buffer=1M set-variable = sort_buffer=1M default-table-type=InnoDB # Do not load support for Berkley DB tables skip-bdb Regards, Michael --- Heikki Tuuri <[EMAIL PROTECTED]> wrote: > Michael, > > what is your my.cnf like? Which my.cnf options did > not work in the plain > 4.0.2 rpm? > > The difference between 4.0 and Max-4.0 is that Max > supports also BDB tables. > > Regards, > > Heikki > > ----- Original Message ----- > From: "Michael Ivanyo" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.mysql > Sent: Saturday, July 13, 2002 7:23 AM > Subject: Re: My.cnf problem when upgrade from 4.01 > to 4.02 > > > > Hello, > > > > I've experienced what seems to be the same problem > on > > Redhat 7.2. I eventually realized that in addition > to > > the regular 4.0.2 server RPM, I had to also > install > > the MySql-Max 4.0.2 server RPM. After that, > > everything worked fine. > > > > I was under the impression that there would only > be > > one server that supported all table types > beginning > > with version 4.0, and that the Max server would no > > longer be needed. That doesn't seem to be the > case. > > > > --Michael > > > > --- zlab1 <[EMAIL PROTECTED]> wrote: > > > Hi, > > > I'm a new user of mysql, I was upgrade from > > > mysql 4.01 to 4.02 in > > > mandrake 8.2. > > > > > > The following options in current running my.cnf > > > suddently not work: > > > > > > innodb_data_file_path = ibdata1:100M > > > innodb_data_home_dir = /data/mysql/ > > > innodb_log_group_home_dir = /data/mysql/ > > > innodb_log_arch_dir = /data/mysql/ > > > innodb_flush_log_at_trx_commit = 1 > > > innodb_log_archive = 0 > > > set-variable = innodb_mirrored_log_groups=1 > > > set-variable = innodb_log_files_in_group=3 > > > set-variable = innodb_log_file_size=4M > > > set-variable = innodb_log_buffer_size=4M > > > set-variable = innodb_buffer_pool_size=64M > > > set-variable = > innodb_additional_mem_pool_size=4M > > > set-variable = innodb_file_io_threads=4 > > > set-variable = innodb_lock_wait_timeout=50 > > > set-variable = innodb_thread_concurrency=8 > > > > > > I change the 1st: > > > innodb_data_file_path = ibdata1:100M > > > To > > > innodb_data_file_path = > > > /data/mysql/ibdata1:100M:autoextend > > > > > > I have to remark rest options in order to make > it > > > working and also > > > "set-variable = " seen not needed?? The err log > > > show: > > > > > > ERROR: unknown variable '..................' > > > whenever I keep any options > > > other than the 1st line, > > > All previous section section is working when > remove > > > 'set-variable = '. > > > > > > So the problem isolated to innodb options > > > sections and seen no doc > > > refer this change, would u kind enough to give > me a > > > hand. > > > > > > Most of the options is copy from example config > file > > > with minor > > > changes....It is working in 4.0 4.01 and > suddently > > > not work now. Thanks. > > > > > > If possible, > > > Please reply to [EMAIL PROTECTED] > > > > > > > > > > > > --------------------------------------------------------------------- > > > Before posting, please check: > > > http://www.mysql.com/manual.php (the > manual) > > > http://lists.mysql.com/ (the list > > > archive) > > > > > > To request this thread, e-mail > > > <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > > > > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: > > > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! Autos - Get free new car price quotes > > http://autos.yahoo.com > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list > archive) > > > > To request this thread, e-mail > <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __________________________________________________ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
