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
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
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.
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