I ran rpm -Uhv MySql*3.23.32-1.i386.rpm against the sever, the client and the
shared rpms.
It ran without error and created the appropriate files on the 10 gig
/var/lib/mysql.
I moved the contents of mysql to /dbshare and created a symbolic link in /var/lib
called mysql which pointed to /dbshare.I set the ownership of the link, /dbshare,
/dbshare/mysql and everything in /dbshare/mysql to "mysql w group root". When I
did that, safe_mysqld was successful in starting mysql from root.
"Gerald L. Clark" wrote:
> You should have run install_db --user=mysql
> Is the mysql directory in /dbshare owned by mysql ?
> Are the permissions 775 ?
> Does mysql own the files in /dbshare/mysql ?
>
> kentj wrote:
> >
> > dbshare is owned by mysql with group deamon
> > and I have run install_db
> >
> > "Gerald L. Clark" wrote:
> >
> > > kentj wrote:
> > > >
> > > > Platform Suse 7.0,
> > > > AMD 450 KIII+,
> > > > 128MB Ram
> > > >
> > > > Linux on 10 Gig system harddrive
> > > > with 45 Gig additional drive mounted as /dbshare.
> > > >
> > > > I have created a symbolic link in /var/lib of mysql-> /dbshare.
> > > >
> > > > then
> > > >
> > > > RPM -Uhv --force MySQL*-3.23.32-1.i386.rpm to install the files
> > > > from
> > > > MySQL-3.23.32-1.i386.rpm
> > > > MySQL-client-3.23.32-1.i386.rpm
> > > > MySQL-shared-3.23.32-1.i386.rpm
> > > >
> > > > The folders mysql and test are placed in /dbshare and mysql.sock is also
> > > >
> > > > created in /dbshare along with the following
> > > > error message.
> > > >
> > > > 010202 13:31:48 mysqld started
> > > > 010202 13:31:48 /usr/sbin/mysqld: Can't find file: './mysql/host.frm'
> > > > (errno: 13)
> > > > 010202 13:31:48 mysqld ended
> > > >
> > > > What am I missing to make this work?
> > > Privileges for the mysql user to access these directories.
> > > Who owns /dbshare?
> > > The privileges that count are the privileges of the real directory,
> > > not the symbolic link.
---------------------------------------------------------------------
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
