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
