import mysql database into mariadb

5
votes

Tried importing a database backup(.sql) from docker container mysql:5.6 into my local MySQL(MariaDB).

Here is the commands I've used:

mysql -u root -p database_name < /opt/database.sql  
mysql -u root -p  database=database_name </opt/database.sql

Also wanna try mysqlimport but I always encounter the same error.

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

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

1
mysqldatabaseimportmariadb
Remove the first 4 lines from your sql file and try again – Hackerman
@Hackerman thank you for the response but still no luck bro. – Řoy Dävid Tolédäno
Can you post the first 10 lines of you sql file? – Hackerman
@Ullas It's my first post here in stack overflow sorry for the wrong format. Thank you very much! – Řoy Dävid Tolédäno
@Hackerman Here it is bro: mysql Ver 14.14 Distrib 5.6.33, for Linux (x86_64) using EditLine wrapper Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Usage: mysql [OPTIONS] [database] -?, --help Display this help and exit. -I, --help Synonym for -? darn bad format sorry! – Řoy Dävid Tolédäno

1 Answers

5
votes

You tried to create a dump with mysql command line client instead of mysqldump.