Okay, I've finally gotten around to trying to create an InnoDB database. I've configured MySQL on Linux Red Hat 6.2, mysql 3.23.44 with the --with-innodb parm. Everything installed wonderfully.
When I start up mysqld, the datafiles and logfiles are created just fine. But, when everything is done the following error appears: /usr/local/mysql/mysql-3.23.44-innodb/libexec/mysqld: Table 'mysql.host' doesn't exist I haven't yet found where the 'mysql.host' table comes from or where it's supposed reside. Anyone got any ideas while I work through the documentation I have available. Below is the full log file from the creation, along with the my.cnf file. Thanks, --Walt Weaver Bozeman, Montana Log from database creation: InnoDB: The first specified data file /data/mysql-3.23.44-innodb/ibdata1 did not exist: InnoDB: a new database to be created! InnoDB: Setting file /data/mysql-3.23.44-innodb/ibdata1 size to 2000 MB InnoDB: Database physically writes the file full: wait... InnoDB: Data file /data/mysql-3.23.44-innodb/ibdata2 did not exist: new to be created InnoDB: Setting file /data/mysql-3.23.44-innodb/ibdata2 size to 2000 MB InnoDB: Database physically writes the file full: wait... InnoDB: Data file /data/mysql-3.23.44-innodb/ibdata3 did not exist: new to be created InnoDB: Setting file /data/mysql-3.23.44-innodb/ibdata3 size to 2000 MB InnoDB: Database physically writes the file full: wait... InnoDB: Data file /data/mysql-3.23.44-innodb/ibdata4 did not exist: new to be created InnoDB: Setting file /data/mysql-3.23.44-innodb/ibdata4 size to 2000 MB InnoDB: Database physically writes the file full: wait... InnoDB: Log file /data/mysql-3.23.44-innodb/ib_logfile0 did not exist: new to be created InnoDB: Setting log file /data/mysql-3.23.44-innodb/ib_logfile0 size to 30 MB InnoDB: Log file /data/mysql-3.23.44-innodb/ib_logfile1 did not exist: new to be created InnoDB: Setting log file /data/mysql-3.23.44-innodb/ib_logfile1 size to 30 MB InnoDB: Log file /data/mysql-3.23.44-innodb/ib_logfile2 did not exist: new to be created InnoDB: Setting log file /data/mysql-3.23.44-innodb/ib_logfile2 size to 30 MB InnoDB: Doublewrite buffer not found: creating new 011205 09:38:36 mysqld ended InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 011205 9:38:36 InnoDB: Started 011205 9:38:36 /usr/local/mysql/mysql-3.23.44-innodb/libexec/mysqld: Table 'mysql.host' doesn't exist 011205 9:38:36 /usr/local/mysql/mysql-3.23.44-innodb/libexec/mysqld: Normal shutdown 011205 09:38:36 mysqld ended my.cnf file: [client] port = 3306 [mysqld] port = 3306 skip-locking #skip-networking #skip-name-resolve # skip-grant-tables log-update set-variable = key_buffer=200M set-variable = sort_buffer=50M set-variable = record_buffer=25M set-variable = tmp_table_size=16M set-variable = max_allowed_packet=1M pid-file = /var/run/mysqld.pid #InnoDB stuff innodb_data_file_path = ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M innodb_data_home_dir = /data/mysql-3.23.44-innodb set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = /data/mysql-3.23.44-innodb set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 #.._arch_dir must be the same as .._log_group_home_dir innodb_log_arch_dir = /data/mysql-3.23.44-innodb innodb_log_archive=0 set-variable = innodb_buffer_pool_size=150M set-variable = innodb_additional_mem_pool_size=20M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 --------------------------------------------------------------------- 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
