>Description: When I tried to start MySQL server with shell>/usr/bin/safe_mysqld & it gave me the error: ----------------------------------------------------------------- Starting mysqld daemon with databases from /var/lib/mysql 030128 08:56:42 mysqld ended ---------------------------------------------------------
The log file "/var/lib/mysql/stvme2.log" has only following: ------------------------------------------------------------ /usr/libexec/mysqld, Version: 3.23.52-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id Command Argument ------------------------------------------------------------ The log file "/var/log/mysqld.log" has the followings: ------------------------------------------------------ 030128 08:56:42 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 030128 8:56:42 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errn o: 13) 030128 08:56:42 mysqld ended ------------------------------------------------------------------------------ I did put the line innodb_data_file_path = ibdata1:10M:autoextend on the mentioned place now it gaves the same error with log: -------------------------------------------------------------- 030128 09:56:44 mysqld started 030128 9:56:44 InnoDB: Out of memory in additional memory pool. InnoDB: InnoDB will start allocating memory from the OS. InnoDB: You may get better performance if you configure a bigger InnoDB: value in the MySQL my.cnf file for InnoDB: innodb_additional_mem_pool_size. InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 030128 9:56:44 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 030128 9:56:45 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 030128 9:56:45 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 030128 9:56:46 InnoDB: Started 030128 9:56:46 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 030128 09:56:46 mysqld ended -------------------------------------------------------------------------------- It would be great if one could help me on this. Thanks in advance, Ozlem >How-To-Repeat: >Fix: <how to correct or work around the problem, if known (multiple lines)> >Submitter-Id: Ozlem Celik >Originator: development >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: <synopsis of the problem (one line)> >Severity: <[ non-critical | serious | critical ] (one line)> >Priority: <[ low | medium | high ] (one line)> >Category: mysql >Class: <[ sw-bug | doc-bug | change-request | support ] (one line)> >Release: mysql-3.23.52 (Source distribution) >Environment: <machine, os, target, libraries (multiple lines)> System: Linux stvme2.astro.ucla.edu 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-sh\ ared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib --enable-__cxa\ _atexit Thread model: posix gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LA\ RGEFILE_SOURCE' CXX='g++' CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_ \LIBC: lrwxrwxrwx 1 root root 14 Jan 10 07:06 /lib/libc.so.6 -> libc-2.2.93.so -rwxr-xr-x 2 root root 1235468 Sep 5 16:12 /lib/libc-2.2.93.so -rw-r--r-- 1 root root 2233342 Sep 5 15:59 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Sep 5 15:50 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --datadir=/usr/share --\ libdir=/usr/lib --mandir=/usr/share/man --infodir=/usr/share/info --without-readline --without-debug --en\ able-shared --with-extra-charsets=complex --with-bench --localstatedir=/var/lib/mysql --with-unix-socket-\ path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql --with-extra-charsets=all --with-innodb --enable-\ local-infile --enable-large-files=yes --enable-largefile=yes --with-berkeley-db --with-thread-safe-client\ 'CFLAGS=-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' 'CXXFLAGS=-\ O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti -fno-excepti\ ons' --------------------------------------------------------------------- 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