Andy Chase

I had a largeish (7.8Mb) SQL export that I had retrieved via PhpMyAdmin, and I was trying to use the MySQL command-line client's batch mode to import it:

mysdl -umyusername -pmypassword mydatabasename

All MySQL returned was 'bye', and nothing in the SQL file got executed.

I looked at the line-break encoding of the SQL file in TextWrangler and noticed that it was set to 'Macintosh'. (\r). On a hunch, I changed it to 'DOS'(\r\n), saved the file, and re-tried the import. Worked like a charm.