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
- Login to post comments
Popular
Recently Perused
- @larryblamire I thought it was perfectly cromulent. — 4 years 43 weeks ago
- Savard hat trick! #bruins — 4 years 43 weeks ago
- Our annual Christmas tree sale is underway! Stop by and get a tree, or just say hello! http://twitpic.com/sekwg (via @nquabbinlodge) — 4 years 43 weeks ago
- Three cheers for the #drupal search_config module! Exclude node types from indexing & search results, etc. http://is.gd/5cxrZ — 4 years 43 weeks ago
- Merry Christmas, or as I like to call it, "Whinge About Being Inclusive to non-Christians Winter Solstice Season" — 4 years 43 weeks ago