>Description:
followed instructions in manual to remove existing files in data directory and
replace. on doing so, get errors when i try to start using "sudo safe_mysqld
--user=mysql &". error log reads:
---
021210 17:05:07 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
021210 17:05:08 /usr/local/mysql/bin/mysqld: Can't find file: './mysql/host.frm'
(errno: 13)
021210 17:05:08 mysqld ended
---
reason for trying to regenerate files: "hostname" in mac os x gives strange results -
so mysql used a temporary dhcp identifier, because i wasn't aware of this peculiarity.
obviously this caused problems. after giving "sudo hostname 127.0.0.1", i tried to
regenerate the files and restart the server. then the errors.
more generally, should one configure hostname to 127.0.0.1 in the /etc/hostconfig file?
>How-To-Repeat:
just as described above and in the relevant section of the manual.
>Fix:
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
>MySQL support: [none X| licence | email support | extended email support ]
>Synopsis: cannot start server after replacing data directory files
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.23.53-entropy.ch (http://www.entropy.ch/software/macosx/mysql/)
>Environment:
System: Darwin 127.0.0.1 6.2 Darwin Kernel Version 6.2: Tue Nov 5 22:00:03 PST 2002;
root:xnu/xnu-344.12.2.obj~1/RELEASE_PPC Power Macintosh powerpc
Mac OS X: 10.2; perl 5.8.0
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/libexec/gcc/darwin/ppc/3.1/specs
Thread model: posix
Apple Computer, Inc. GCC version 1161, based on gcc version 3.1 20020420 (prerelease)
Compilation info: CC='gcc' CFLAGS='-DHAVE_BROKEN_REALPATH -lncurses' CXX='g++'
CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxr-xr-x 1 root wheel 15 Dec 2 17:03 /usr/lib/libc.dylib -> libSystem.dylib
Configure command: ./configure --prefix=/usr/local/mysql
--localstatedir=/usr/local/mysql/data --libdir=/usr/local/mysql/lib
--includedir=/usr/local/mysql/include --with-named-z-libs=/usr/local/libz.a
--with-innodb --with-server-suffix=-entropy.ch
--with-comment=http://www.entropy.ch/software/macosx/mysql/ --with-mysqld-user=mysql
--enable-assembler 'CFLAGS=-DHAVE_BROKEN_REALPATH -lncurses'
'CFLAGS=-DHAVE_BROKEN_REALPATH -lncurses'
---------------------------------------------------------------------
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
