hi, where are you running the server from? you might wanna try running from the base dir
./bin/safe_mysqld & i used to have the same problem. on a linux machine though. regards, On Fri, 3 May 2002, Olivier Delrieu wrote: > > Dear all, > > I've installed Cygwin and CAMP and I'm now looking for guidelines to build/install >mysql under cygwin and XPpro. Sorry > for that question but I tried during severals days with no luck. > > I'm using the scripts provided by Gerrit P. Haase in > http://sources.redhat.com/ml/cygwin/2001-12/msg00025.html > with mysql-3.23.49.tar.gz > > At the end of the installation process, I get the following error when starting >mysql deamon : > > /src/mysql/mysql-3.23.49> Starting mysqld daemon with databases from >/var/mysql/data > 020503 7:15:49 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: >0) > 020503 07:15:49 mysqld ended > > This error has been already discussed in several mailing lists, the solution was to >chown /var/mysql/data with user > mysql, but it does not work here. > > I used the following procedure : > > - add user mysql and group cyg_mysql in XP (I log with username 'Administrateur') > - add user and group to cygwin files with > mkpasswd -l > /etc/passwd > mkgroup -l > /etc/group > - installation in /scr/mysql > - mysql.build prep => ok > - patch -p0 < ../mysql.patch => ok > - mysql.build conf => ok > - mysql.build build > stops with errors in make info : > make[1]: Leaving directory `/src/mysql/mysql-3.23.49/bdb' > make: *** [info-recursive] Error 1 > - mysql.build install => ok > - mysql.build initdb => ok, but > ./scripts/mysql_install_db says : > Preparing db table > Preparing host table > Preparing user table > Preparing func table > Preparing tables_priv table > Preparing columns_priv table > Installing all prepared tables > ERROR: 1033 Incorrect information in file: './mysql/db.frm' > ... > 020503 8:16:00 /usr/libexec/mysqld: Shutdown Complete > > - mysql.build startdb > => stops with 'mysqld ended' : > cat /var/mysql/data/EXBRAYAT.err > /src/mysql/mysql-3.23.49> Starting mysqld daemon with databases from >/var/mysql/data > 020503 7:15:49 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' >(errno: 0) > 020503 07:15:49 mysqld ended > > Of course, there is no file in /var/mysql/data/mysql/ ... > > when I cp /dev/null to mysql/host.frm the deamon can access the file and the error >become : > 020503 8:28:58 /usr/libexec/mysqld: Incorrect information in file: >'./mysql/host.frm' > 020503 08:28:58 mysqld ended > > > > So, the installation process did not create the mysql database. but why ? Is there a >patch to apply in > ./scripts/mysql_install_db ? > > Fortunately, I have also installed mysql under XP, and when I copy the XP/mySQL >databases to the CygWin/mySQL ones, > everything (camp & mysqld) is working perfectly, except it is a mess with usernames >... > > Mr Haase, could you help ? :-) > > thanks, > > Olivier. > > > > --------------------------------------------- > Olivier Delrieu > [EMAIL PROTECTED] > Phone : +33 1 44 89 77 59 > : +33 1 44 89 77 50 (secretariat) > Mobile : +33 6 64 63 00 15 > --------------------------------------------- > > > --------------------------------------------------------------------- > 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 > -- _________________________________________________________________ TP R Murthy (Systems Analyst) Cerulean Information Technology Pvt. Ltd. #24, floor#2, 5th Main, 5th Block, Koramangala, Bangalore-560 095. Phone: 299-1886, 299-1897 web:http://www.ceruleaninfotech.com _________________________________________________________________ Life is a Dream. Dont Wake up. --------------------------------------------------------------------- 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