Home › Archive › 2005 › September › MySQL Batch Mode doesn't like Mac line breaks

MySQL Batch Mode doesn't like Mac line breaks

23 Sep, 2005

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.

Also

Syndicate content

Twitter

  • After a video chat with @wstites I am reminded that we live in the future, despite the conspicuous lack of personal jetpacks. — 6 years 28 weeks ago
  • Lazyweb: What #drupal solutions are there for limiting the num. of accounts a given user can create? — 6 years 28 weeks ago
  • Being able to check POP3 accounts via telnets is handy: http://bit.ly/OoPV7 — 6 years 29 weeks ago
more

Older

Contact

Andy Chase
(978) 297-6402
andychase [at] gmail.com
GPG/PGP Public Key