Problem with Schema on MySql Server

[reycons]

I copied the schema name geneticdatabase in c:\AppServ\MySQL\data\geneticdatabase from one PC and paste to another PC in c:\AppServ\MySQL\, when I open the schema in the MySQL Server and the table named class_setup, the fields cannot be loaded and I've got an error message saying:

SELECT c.`Could not fetch columns` FROM geneticdatabase.class_setup c;

 

[Kozusnik]

You'll have to stop MySQL before making the copy.

Or...on Windoze, you can use mysqldump.
On Linux, use mysqlhotcopy (for ISAM/MYISAM tables).

Mark