MySQL dump (импорт большой базы)
mysql -u ИмяЮзера -pПарольЮзера -h localhost ИмяБазы < dump.sql

MySQL backup
mysqldump -u ИмяЮзера -pПарольЮзера ИмяБазы > /dumps_folder/dump.sql

MySQL export CSV
SELECT * FROM `my_table` WHERE 1 INTO OUTFILE "/dumps_folder/dump.csv" FIELDS TERMINATED BY ',' LINES TERMINATED BY "\n";

MySQL изменить кодировку таблицы
ALTER TABLE your_table CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE your_table DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;