469,609 Members | 1,092 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,609 developers. It's quick & easy.

Importing MySQL databases to a MySQL server on another machine

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\MySQL 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.frm
criminalorganization.frm
criminaltype.frm
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?
Apr 19 '07 #1
1 2269
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
Apr 20 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

17 posts views Thread by chicha | last post: by
4 posts views Thread by wzhao6898 | last post: by
5 posts views Thread by linuxlover992000 | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.