469,927 Members | 1,772 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Importing a MySQL Database from .frm, .myi and .myd files

Hello,
I have the contents of a MySQL database sitting in a folder. Each file
in the folder is an ISAM table that is comprised of three files, its
..frm, .MYI and .MYD. I would like to import this database on another
MySQL installation running on another machine. I thought it would be
as simple as mysqladmin create <database_name> and then navigating to
the databases data directory and dropping in the ISAM files, however,
when I connect to the database using mysql I get "Didn't find any
fields in table <table_name>" for each of the 16 or so tables I tried
to copy over. Any advice would be much appreciated.

- Harry
Jul 20 '05 #1
2 17999
Harry wrote:
Hello,
I have the contents of a MySQL database sitting in a folder. Each file
in the folder is an ISAM table that is comprised of three files, its
.frm, .MYI and .MYD. I would like to import this database on another
MySQL installation running on another machine. I thought it would be
as simple as mysqladmin create <database_name> and then navigating to
the databases data directory and dropping in the ISAM files, however,
when I connect to the database using mysql I get "Didn't find any
fields in table <table_name>" for each of the 16 or so tables I tried
to copy over. Any advice would be much appreciated.

Try creating a new table in that database, see if something is different.

Leif
Jul 20 '05 #2
I know with myisam tables, i could just copy the files without even
doing a "create database" command. (mind you I've never been 100% sure
that it is the safest thing to do.) Make sure you flush the tables
first. Would like to read more opinions on this myself.

Harry wrote:
Hello,
I have the contents of a MySQL database sitting in a folder. Each file
in the folder is an ISAM table that is comprised of three files, its
.frm, .MYI and .MYD. I would like to import this database on another
MySQL installation running on another machine. I thought it would be
as simple as mysqladmin create <database_name> and then navigating to
the databases data directory and dropping in the ISAM files, however,
when I connect to the database using mysql I get "Didn't find any
fields in table <table_name>" for each of the 16 or so tables I tried
to copy over. Any advice would be much appreciated.

- Harry

Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Campbell's List | last post: by
reply views Thread by Thomas Bartkus | last post: by
6 posts views Thread by Oliver Spiesshofer | last post: by
2 posts views Thread by Joel | last post: by
2 posts views Thread by Jean Bidule | last post: by
5 posts views Thread by Vik Rubenfeld | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.