George:
Suggest you use mysqldump, including the option to automagically create the
database and table schema.
On the WinNT machine:
mysqldump -u{username} -p -c --databases {databasename}>{databasename}.sql
Copy the file(s) across the network to the LinuxPPC box
On the LinuxPPC box:
mysql -u{username} -p<{databasename}.sql
Gerald Jensen
----- 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
