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
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:
>
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)
> >
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
> crea
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 'classe
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,
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 2
>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 copie