[SOLVED] Error importing MySQL data across platforms (MAMP to WIMP)

Error importing MySQL data across platforms (MAMP to WIMP)

I've dumped a MySQL database I have on my local MAMP server into a .sql file. Usually, it's easy enough for me to import that file to my production Linux servers without a hitch. However, my current client runs MySQL on WIMP, and when import the MAMP-generated .sql dump into my WIMP mysql environment (Using pphpMyAdmin) I get a "File could not be read" error?

Any ideas of what I'm bumping up against, or what to check? Thanks-

EDIT:

My initial explanation was unclear- I'm trying to export out of MAMP, and import into WIMP

Solution

The most likely cause for this problem is the different end of line conventions on DOS and UNIX platforms. Windows uses the DOS convention of '\r\n' for newlines, while Mac OSX and Linux use the UNIX convention of '\n' for newlines. To fix the problem, run the unix2dos utility on the mysql dump file on your Mac and then copy the file to your Windows box.