mysqldump <database> --password=<password> --user=<user> --default-character-set=utf8 > <file>
on windows, use --result-file=<file>
as default export is in UTF16
(or mariadb-dump)
mysql -u <username> <databasename> < <filename.sql>
mysqlshow
mysql --user=root --execute="CREATE DATABASE nick_notas_new COLLATE = utf8mb4_unicode_520_ci;"