MySQL Batch Mode doesn't like Mac line breaks

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

  • It's about time http://flic.kr/p/8GcTE9 3 years 40 weeks ago
  • Don't use twitter much any more, ayuh. 3 years 41 weeks ago
  • Lazyweb: Does there exist a #drupal module for selectively disabling CCK fields without deleting them? Perhaps field permissions... 3 years 41 weeks ago
  • New post: Old Joe (Minstrel Banjo) http://tinyurl.com/3yyg8g9 3 years 45 weeks ago
  • New post: Emacs Org-mode: Custom agenda that filters by date AND tag http://tinyurl.com/2vnrcl2 3 years 45 weeks ago

Older

Contact

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