On Mon, 23 Apr 2001, New Style MySQL Personnel wrote:
>
> Please anyone. I really need some ideas.
> I copied my database files made with 23.29 to 23.26 and now I get this. I
> chowned mysql.mysql and chmoded 660.
> The location of the databases is good because I have some other databases
> created with 36 and they work fine. I copied ALL the database's files to
> /var/lib/mysql where the others are and I get this error. Any idea?
>
> mysql> use lumina;
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> 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: './lum/users.frm' (errno: 13)
Error code 13 means permission denied. How come your database is named 'lumina' and
the directory it resides in (or at least the dir that mysql tries to find the tables
in) is ./lum/ ? Shouldn't it be looking under lumina?
Check that you don't have your database directories messed up under ~mysql/var/
regards,
thalis
> It's funny; that file exists!
>
> It's urgent! Thanx!
>
>
> ---------------------------------------------------------------------
> 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
