Transfer MySQL data from Windows to Linux

[TheFoxy]

If a Windows MySQL DB is started, tables created, data put in, etc, can the tables/data etc be moved to a Linux MySQL DB at a later date?

 

[sleipnir214]

Yes. Certainly by a less direct method, possibly by a more direct method.

If you use mysqldump to output the SQL code to reproduce your database, that data created is completely portable.

Since MySQL creates a filesystem directory for every database, and files on the filesystem for every table, you can move data by simply copying those files across. This works between two MySQL systems on two different Linux boxes. I don't know about Win32->Linux.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[apatterno]

I just copied all the files from C:\mysql\data into /usr/local/mysql/data, and did [tt]`chown mysql *'[/tt] and [tt]`chgrp mysql[/tt] *'. Flawless as far as I know.

_{I REALLY hope that helps.}
Will

 

[abombss]

Just make sure the server is not running or all the tables are locked when copying or they might end up corrupt. If bandwidth is an issue you do not need move index files, you can rebuild those later.

Check the mysqlhostcopy.pl script, its a great tool for this kind of stuff, it even has some support for scp.

abombss