Re: Need help with 23.36

2001-04-24 Thread New Style MySQL Personnel



mysql use lum
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 'users'
Database changed
mysql select * from users;
ERROR 1017: Can't find file: './lum/users.frm' (errno: 13)

  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?
 
 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/


The files are in the right directory with the right permissions and still
I get the errors from above.


-
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




Need help with 23.36

2001-04-23 Thread New Style MySQL Personnel


I copied my database files made with 23.29 to 23.26 and now I get this. I
chowned mysql.mysql and chmoded 660. What's wrong?

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

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




Need help with 23.36

2001-04-23 Thread New Style MySQL Personnel


I copied my database files made with 23.29 to 23.26 and now I get this. I
chowned mysql.mysql and chmoded 660. What's wrong?

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

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




Re: Need help with 23.36

2001-04-23 Thread New Style MySQL Personnel


The location 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?

On Mon, 23 Apr 2001, B. van Ouwerkerk wrote:


 I copied my database files made with 23.29 to 23.26 and now I get this. I
 chowned mysql.mysql and chmoded 660. What's wrong?

 Perhaps or.. the location of your database is different.. or.. you
 didn't copy everything.. including subdirectories.

 Solution: check the location and if you copied all files..

 Bye,


 B.


 -
 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




Need help with 23.36

2001-04-23 Thread New Style MySQL Personnel


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)

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