You've exported a MySQL dump (say the file is <code>my-db.sql</code>) from Windows in Powershell or via phpMyAdmin. Now you want to import the MySQL file, <code>my-db.sql</code>, on a Ubuntu machine. You get the error :
<pre><code class="lang-bash">ERROR: ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode.
</code></pre>
Run this command on your Ubuntu machine :
<pre><code class="lang-bash">iconv -f utf-16 -t utf-8 my-db.sql &gt; my-db_utf8.sql
</code></pre>
Now import <code>my-db.sql</code> via <code>mysql --user=username --database=my-db_utf8 -p &lt; my-db.sql</code>. It should work.
PS: Incase you're not sure what kind of file <code>my-db.sql</code> is, try running <code>file my-sb.sql</code> in the Ubuntu terminal. For example :
<pre><code class="lang-bash">file my-db.sql
my-db.sql: Little-endian UTF-16 Unicode text, with very long lines, with CRLF line terminators
</code></pre>

You've exported a MySQL dump (say the file is `my-db.sql`) from Windows in Powershell or via phpMyAdmin. Now you want to import the MySQL file, `my-db.sql`, on a Ubuntu machine. You get the error :

```bash
ERROR: ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode.
```

Run this command on your Ubuntu machine :

```bash
iconv -f utf-16 -t utf-8 my-db.sql > my-db_utf8.sql
```

Now import `my-db.sql` via `mysql --user=username --database=my-db_utf8 -p < my-db.sql`. It should work.

PS: Incase you're not sure what kind of file `my-db.sql` is, try running `file my-sb.sql` in the Ubuntu terminal. For example :

```bash
file my-db.sql
my-db.sql: Little-endian UTF-16 Unicode text, with very long lines, with CRLF line terminators
```

ASCII '\0' appeared in the statement Error

Converting a file from Windows format (utf-16) to Ubuntu format (utf-8)

General Ubuntu stuff - frankly speaking it's really notes to self
