Re: Need help with 23.36
COuld try a mysqldump to backup and restore the tables on the new/other machine. This should get you past the problems you found earlier. Remember to add the propriate users to the new machine.. Bye, B. > > >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 - 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
New Style MySQL Personnel wrote: > > > > 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. > > Show us, with an ls -l of that directory. - 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
> 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
Re: Need help with 23.36
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
RE: Need help with 23.36
Hi, > 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) errno 13 stands for "Permission denied" - check your mysql data directory permissions. Rgds, Tfr --==< [EMAIL PROTECTED] >==< MySQL development team >==< Tallinn / Estonia >==-- - 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
chown -R mysql /var/lib/mysql New Style MySQL Personnel wrote: > > 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 - 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
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
Re: Need help with 23.36
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
Re: Need help with 23.36
>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
Need help with 23.36
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
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