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