On Tue, 8 May 2001, Jeremy Zawodny wrote:
> On Tue, May 08, 2001 at 03:15:31PM -0700, David Potter wrote:
>
> > I have a question on moving a MySQL database from a Windows Me
> > machine to a Linux machine. Most of our tables have over 22 million
> > rows. I suppose the slow but safe way is to dump the whole database
> > on the Windows machine using mysqldump and then ftp the dump file
> > over to the Linux box. But to save time can I just ftp over the
> > files in the /data directory in ascii mode ? Or does Mysql store
> > the data differently in Windows vs Unix and I have to do this the
> > slower way as mentioned above ? Thank you.
>
> MySQL 3.23.xx uses a platform independant format for the data. So just
> shut down the server and copy all the *.MYD *.MYI *.frm files over to
> Linux and go from there.
>
> Sure beats the time needed to dump and reload the data on the other
> end.
>
> Jeremy
Yes, true. But is it safe to ftp them in ASCII mode as mentioned? I'd go for binary
mode instead.
thalis
---------------------------------------------------------------------
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
