Ashish Tripurwar
Ashish Tripurwar

Reputation: 161

MariaDB unable to import this dump file

I have MariaDB version 5.5.39

mysqldump -u root -p database > dumpfile.sql

Yes this is working fine; it produces a dump file.

But I am not able to import this dump file. All these commands are not working:

mysqldump -u root -p database < dumpfile.sql

mysqlimport -u root -p database < dumpfile.sql

mysql -u root -p database < dumpfile.sql

Can anybody help me please?

Upvotes: 8

Views: 13001

Answers (1)

Federico Razzoli
Federico Razzoli

Reputation: 5351

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

Upvotes: 18

Related Questions