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
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 125 days, processed 774,627,600 queries (71/sec. avg)
---------------------------------------------------------------------
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