Export and Import database MySQL/MariaDB

Export (add dump) >

$ mysqldump -u username -p databasename > /home/file.sql
$ mysqldump -u username -p databasename | gzip > /home/file.sql.gz

Import <

$ mysql -u username -p databasename < /home/file.sql

or with source

mysql> use database
mysql> source /home/file.sql