Dammit, never mind. I figured it out. Maybe someday I'll be able to ask an intelligent question here...
--Walt -----Original Message----- From: Weaver, Walt Sent: Wednesday, December 05, 2001 10:09 AM To: [EMAIL PROTECTED] Subject: Error trying to create InnoDB database. HELP 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
