i use this in linux :
sed -i 's/utf8mb4/utf8/g' your_file.sql
sed -i 's/utf8_unicode_ci/utf8_general_ci/g' your_file.sql
sed -i 's/utf8_unicode_520_ci/utf8_general_ci/g' your_file.sql
then restore your_file.sql
mysql -uyourdbuser -pyourdbpasswd yourdb < your_file.sql
Recent Comments