472,110 Members | 2,224 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,110 software developers and data experts.

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:


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 2364
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 leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.