title: import mysql database into mariadb
body: <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>