transfer of database

[tvrtko]

What should I do to transfer my database from one instance of MySQL Server to another(same version).

Sorry on newbie question.

 

[tchatzi]

the easiest way in your case (because both servers are the same versions) is to copy your database directory and paste it to the other server, and then restart the server.

the right way to do it, is 'mysqldump --help'


``The wise man doesn't give the right answers,
he poses the right questions.''
TIMTOWTDI

 

[tvrtko]

I did that, and now I can connect to the database, but after select statement on table I get message:

ERROR 1016: Can't open file: 'myTable.ibd' (errno: 1)

 

[KarveR]

what OS are your servers?
have you got the right permissions?
did you also copy the my.cnf from one server to another?



______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[tvrtko]

It's MySQL Server 4.1 on Windows XP.
I think permissions are all right. I can connect to database.

I didn't copy the my.cnf from one server to another.