MySQL 5.0 copy of DB binary files

[stevehart]

Hi
I'm using MyDQL 5.0 with Administrator 1.2.11 on an XP OS. I'm attempting to copy a database by simply copying the data directory and binary files, and then renaming it. MySQL Admin can see the new database and I can connect to it via ODBC. While the MySQL Admin catalog for this DB lists all the tables, it displays an error that all the tables do not exist. Any ideas/help appreciated -

 

[Kozusnik]

When moving the "files", I've found that you need to stop and restart mysql. Next time, I'd use mysqldump or mysqlhotcopy (linux).

Mark