Those are the actual table files that MySQL uses for the MyISAM table type.
You should be able to just copy them into the datadir under a database
directory and MySQL will find them and you should be able to use the tables
like normal after copying them.  If you don't know where your datadir is you
can find out by doing a SHOW VARIABLES like 'datadir'.  I recommend shutting
down the server first as well, or else you could get into some weird data
corruption stuff.
One point that people tend to get stuck on is file permissions after copying
them in.  Make sure they are readable/writable by whomever the mysqld is
running as.

Harrison


----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, May 04, 2002 1:41 PM
Subject: Newbee: importing data from .MYD .MYI .frm


> Hi all,
>
> A colleague has created a database with MySQL. She has provided me three
files
> with the extensions .MYD .MYI .frm, to put them in the server. How can I
> import
> them into MySQL? I have MySQL 3.23.49 in Debian Linux 'potato'. I have
used
> myisamchk to check the database, but I do not know how to do something
else.
>
> Thanks in advance.
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to