change your my.cnf to use the following variables:(I left our info in them for reference)
innodb_data_file_path = ibdata1:400M innodb_data_home_dir = c:\ibdata innodb_log_group_home_dir = c:\iblogs innodb_log_arch_dir = c:\iblogs also make sure the MySQL my.cnf is place in the /etc directory in UNIX or the Windows-system-directory in Windows. The INNodb from what I understand should be set up to run as a global option and not a server-specific option, that is why you should put it in one of the directories above. Scott Pippin >>> Shomal Bafna <[EMAIL PROTECTED]> 10/21/02 08:46AM >>> Sorry, I know this question would best suit for [EMAIL PROTECTED] but there is over limit problem. " E-mail Account: lists-mysql is over the limit of 31457280 bytes." I am running a Mandrake Linux 8.1, with an rpm installed ver 3.23.41. Unfortunately configuring the MySQL for InnoDb for me turned into an intriguing problem. I installed the MySQL-Max 3.23.41 version. And tried to follow instructions but mysql would start if i create an my.cnf (by default this file is missing from installation) [mysqld] innodb_data_home_dir = innodb_data_file_path = /innodb-data/ But on starting the deamon it wouldn't start. Perplexed and trying to trouble shoot where the problem i remarked the entries and mysqld ran. But 'show variables like "have_%"' displayed BDB=YES and InnoDB=DISABLED. How to turn around this problem? Waiting for suggestions. Shomal ===== shomal __________________________________________________ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/doc/ (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <java-unsubscribe-##L=##[EMAIL PROTECTED]> --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/doc/ (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
