Jeremy Falcon writes:
> To be honest, I'm not sure if you can just transport the db files. I'm sure
> it won't work it you're using different versions of MySQL on the machines.
>
> What I do when going from Win2K to FreeBSD is a mysqldump to extract the SQL
> statements to recreate the table. I'll use SELECT ... INTO OUTFILE to
> export a CSV for each table. On the Unix box I'll use the SQL statements
> from the mysqldump to recreate the tables and the CSV file to import the
> data (using LOAD DATA INFILE).
>
> Oh, to make the move even smoother... If you have gzip running on Win2K,
> then gzip the CSV file and then bring it over to the Linux box. When you
> unzip the file don't forget the -a switch. gzip will automatically convert
> all the \r\n to \n, which is how Unix/Linux like things.
>
> Just remember you need file permissions in MySQL to perform the INFILE and
> OUTFILE operations.
>
> Jeremy
To clear out any confusion, since 3.23.0, MyISAM files can be safely
copied from one OS/CPU combo to other as they have their own OS/CPU
independent format.
Just make sure they are not corrupted.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.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