CODEWITHSUNDEEP
mysqldump
omg
omg

Reputation: 140042

Has anyone tried dumping MySQL data on windows directly to MySQL on linux?

windows:

mysqldump .... > windata.sql;

linux:

mysql ... < windata.sql

Will the data be cross-platform?

Upvotes: 0

Views: 120

Answers (6)

Mark Mayo
Mark Mayo

Reputation: 12615

No problems experienced myself. Some of the alternative encodings may be interesting, as well as case-sensitivity on table names - so check those carefully. But if you're just doing UTF8 and double check the names, you should be fine.

Like all new things, trying it will give you the most accurate answer, let us know what happens!

Upvotes: 1

artemb
artemb

Reputation: 9381

One issue you should be aware of is that by default table names are case insensitive on Windows and case sensitive on Linux. This could be a huge pain (at least it was for me). You can alter it by setting lowercase_table_names (or something like this) in my.cnf on linux

Upvotes: 1

chaos
chaos

Reputation: 124335

I have done so, and it works fine.

Upvotes: 1

Daryl
Daryl

Reputation: 66

I have done it. No problems moving between Windows, Solaris, or Linux.

Upvotes: 0

Omry Yadan
Omry Yadan

Reputation: 33686

should be. actually, even the actual files in the datadir are supposed to be portable (but you need to be careful when copying them, shut down your server first).

Upvotes: 1

KB22
KB22

Reputation: 6979

Crossplatform will probably work. But be aware of encoding issues. ÄÖÜ... ;)

Upvotes: 0

Related Questions