import mysql database into mariadb
<p>Tried importing a database backup(.sql) from docker container mysql:5.6 into my local MySQL(MariaDB). </p>

<p>Here is the commands I've used:</p>

<pre><code>mysql -u root -p database_name &lt; /opt/database.sql  
mysql -u root -p  database=database_name &lt;/opt/database.sql
</code></pre>

<p>Also wanna try mysqlimport but I always encounter the same error.</p>

<blockquote>
  <p>ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'mysql  Ver 14.14 Distrib 5.6.33, for Linux (x86_64) using  EditLine wrapper
  Copy' at line 1</p>
</blockquote>

<p>Can anyone please tell me what is the right syntax on importing database from mysql into mariadb.</p>