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
----- Original Message -----
From: "George Pitcher" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 24, 2001 8:42 AM
Subject: Moving database from NT > Linux
> Hi all,
>
> I'm getting closer and closer to having MySQL/PHP/Apache set up on my
> LinuxPPC box.
>
> Now, I haven't been sitting twiddling my thumbs while I was waiting.
Instead
> I was building a database on MySQL on NT.
>
> I would like to move this to Linux asap. There are 6 tables with between 8
> and 40 fields in them. The largest DB has 350,000 records and the overs a
> bit less (but still a lot).
>
> My question, really, is: Will I have to go through the create database
> process all over again or can I move this DB over from one platform to
> another?
>
> MTIA
>
> George P in Edinburgh
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.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
>
>
---------------------------------------------------------------------
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
