Dumping and importing from/to MySQL/MariaDb in an UTF-8 safe way

mysqldump_command.md

Dumping safely

cd to your backup dir first

mysqldump -uroot -p [database?] -r [name_dump_file?].dump
[enter password]

Importing a dump safely

find dump file or cd to dir location

mysql -uroot -p --default-character-set=utf8 [database?]
[enter password]

mysql> SET names 'utf8';
mysql> SOURCE [name_dump_file?].dump;