Import database into mariadb

mysqldump -u [username] -p [database_name] > backup.sql

mysql -u root -p
CREATE DATABASE new_database;
EXIT;

mysql -u [username] -p new_database < backup.sql

mysql -u root -p

USE new_database;
SHOW TABLES;
SELECT * FROM [table_name];