Do a SQLDUMP using a program like MySQLFront in NT then connect to the Linux MySQL
using the same from NT. Run the SQL script you made and your off to the races.
Just did this for my move from NT to Linux.
There might be even a better way to do this but that's how I did mine and it worked.
Cheers
M;)
-----Original Message-----
FROM: George Pitcher
TO: [EMAIL PROTECTED]
DATE: Fri 8/24/01 7:56
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
