>From MySQL manual:

http://www.mysql.com/doc/M/o/Moving.html

http://www.mysql.com/doc/U/p/Upgrading-to-arch.html

I have tried and it works in HP-Solaris and LINUX, but
I tend to agree with Cal, my recomendation is to use
an alternative procedure such as dumping and
importing.


Bye and Good Luck.

--- Cal Evans <[EMAIL PROTECTED]> wrote:
> 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
> 


__________________________________________________
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com

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