There is something real weird with Fedora Core 1's bindery of MySQL. It works for a while, but then it squawks about innodb needing either parameters set or pass a skip-innodb in the config which I did but still get a [Failed] when I do a "service mysqld start" It is running though, the error at start up time out error and this is in the /var/log/mysqld_log >>---------------/var/log/mysqld_log---------------------------> 040315 23:28:09 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add to the [mysqld] section, for example, innodb_data_file_path = ibdata1:10M:autoextend But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html /usr/libexec/mysqld: ready for connections 040315 23:43:16 /usr/libexec/mysqld: Normal shutdown 040315 23:43:16 /usr/libexec/mysqld: Shutdown Complete 040315 23:43:16 mysqld ended 040315 23:43:16 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add to the [mysqld] section, for example, innodb_data_file_path = ibdata1:10M:autoextend But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html /usr/libexec/mysqld: ready for connections 040315 23:49:57 /usr/libexec/mysqld: Normal shutdown 040315 23:49:57 /usr/libexec/mysqld: Shutdown Complete 040315 23:49:57 mysqld ended 040315 23:49:57 mysqld started /usr/libexec/mysqld: unrecognized option `--inobdb=skip-innodb' /usr/libexec/mysqld Ver 3.23.58 for redhat-linux-gnu on i386 Copyright (C) 2000 MySQL AB, by Monty and others This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Starts the MySQL server Usage: /usr/libexec/mysqld [OPTIONS] >>----------------------End-----------------------------> It's weird that I get a Failed on start up, yet it is running. I have duplicated this on three boxes. If I su to user mysql and run /usr/libexec/mysqld --skip-innodb I get a fast startup and a ready for connections output. What could I use to append the init.d script to pass the option --skip-innodb. It doesn't seem to be working from the config in /etc/my.cnf as described in the error log's. Best Fred
