List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:July 30 1999 8:22pm
Subject:Re: few questions
View as plain text  
On Sa, 1999-07-31 00:05:19 +0500, Faisal Nasim wrote:
> Could you tell me if I can move Windows .FRM/.ISD/.ISM
> files into a Linux MySQL data directory (without loosing
> any data)?

No, as far as I know this won't work!

The most hassle-free method is:

a) make a complete dump of the database or table using
       mysqldump --opt dbname >dumpfile.sql
   or  mysqldump --opt dbname tablename >dumpfile.sql

b) transfer this "dumpfile.sql" to the Linux host

c) feed it to MySQL using
       mysql <dumpfile.sql


If you can access both databases from the same host, you can combine
all three steps into one:
    mysqldump --host=host1 --opt dbname | mysql --host=host2

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
few questionsFaisal Nasim30 Jul
  • Re: few questionsMartin Ramsch31 Jul
  • Re: few questionsRalph Graulich31 Jul