Another option is to use a program like mysqlfront, open both server and local versions of mysql and use export facility in mysqlfront. I've found this particularly useful.
-----Original Message----- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 3:13 PM To: Hanxue Lee; [EMAIL PROTECTED] Subject: RE: MySQL in different OSes 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 --------------------------------------------------------------------- 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