MariaDB cannot import this dump file

Question

I have MariaDB version 5.5.39

mysqldump -u root -p database > dumpfile.sql

Yes, it works fine; this produces a dump file.

But I can not import this dump file. All these commands do not work:

mysqldump -u root -p database < dumpfile.sql

mysqlimport -u root -p database < dumpfile.sql

mysql -u root -p database < dumpfile.sql

Can anyone help me please?

Answer 1

mysql -u root -p --database=db_name < dumpfile.sql