Importing MySQL databases to a MySQL server on another machine

[penny111]

Hi there,

I've migrated a database named "crime" from an MS Access database to MySQL 5.0.37 using the MySQL Migration Toolkit 1.1.11. What i want to do is to copy the database folder from
C:\Program Files\MySQL\MyS QL Server 5.0\data
to the same folder on another machine. So i copied the files directly over, ran MySQL and it recognizes the database (i can see the database included in the list) when i type the command

mysql> show databases;

I can view the tables using the "show tables" command but when i try to access the tables with a select statement, i get the error below:

mysql> select Firstname from criminal;
ERROR 1146 (42S02: Table 'crime.criminal ' doesn't exist

Within the 'crime' folder i copied over are the following files:

crime.frm
crimecomitted.f rm
criminalorganiz ation.frm
criminaltype.fr m
hideouttype.frm

I tried stopping the server, copy the files over and restart the server but i still get the same error. I've looked up other topics such as permissions and backup but i can't seem to find a way to import the database over to the MySQL server on another machine.

Any ideas on how i can fix this error?

[penny111]

I've found the solution to my problem:

-use mysqldump to export the databases to a .dump file
-create an empty database on the target machine
-import the dump file into MySQL on the target machine