On Thu, 5 Apr 2001, Gerald Clark wrote:
I forgot to mention that the permisions are already set to mysql:mysql
660
> MySQL Server wrote:
> >
> > Hy!
> >
> > I have this odd problem. I upgraded my MySql from 3.23.29 to 3.23.36.
> > It works fine with some databases I created with 36.
> > But I copied some databases from 29 and I get this
> >
> > mysql> use lumina;
> > Didn't find any fields in table 'absences'
> > Didn't find any fields in table 'admins'
> > Didn't find any fields in table 'classes'
> > Didn't find any fields in table 'marks'
> > Didn't find any fields in table 'students'
> > Didn't find any fields in table 'teachers'
> > Didn't find any fields in table 'users'
> > Didn't find any fields in table 'vars'
> > Database changed
> >
> > mysql> select * from users;
> > ERROR 1017: Can't find file: './lumina/users.frm' (errno: 13)
> >
> > And the files exist and worked under 29.
> >
> > Tell what do I have to do.
> >
> > Thanx!
> >
> Change the ownership and permissions on the databases/files to allow
> mysqld to read them.
>
> When you copied them, you were not the user mysql.
>
> ---------------------------------------------------------------------
> 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
