Hi,
I think you must run the db_install script.
Good luck,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: TP R Murthy <[EMAIL PROTECTED]>
To: Olivier Delrieu <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, May 03, 2002 1:27 PM
Subject: Re: mySQL under cygwin : mysql_install_db does not create host.frm
> 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
>
>
---------------------------------------------------------------------
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
