Yes and no.

No, you can't (shouldn't) copy the file from one server to another. Bad
Mojo. It MAY work if you are only using MyISAM file types but no promises
there.

You would be much better off using mysqldump to dump the contents of your
databases to a text file and then re-importing them on the other machine.

master
mysqldump -opt > everything.sql

slave
mysql < everything.sql

Warning this will wipe everything on your slave machine as it imports from
the master.

=C=

*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*


-----Original Message-----
From: Hanxue Lee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 12:39 AM
To: [EMAIL PROTECTED]
Subject: MySQL in different OSes


Hi,

I just want to know if I can just copy a MySQL database from, say Windows
2000
to Linux. Will it still work? Does it has binary data compabilities?

Thank you


Yours Truly,
Hanxue


---------------------------------------------------------------------
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