Fix sql dump, Unknown collation: utf8mb4_unicode_ci

gunzip the file first

sed -i '' 's/utf8mb4_unicode_ci/utf8_general_ci/g' backup.sql  
sed -i '' 's/CHARSET=utf8mb4/CHARSET=utf8/g' backup.sql  

https://tecadmin.net/resolved-unknown-collation-utf8mb4_unicode_ci/

or this worked https://meetanshi.com/blog/error-1273-unknown-collation-utf8mb4-0900-ai…
just open the file and do %s/utf8mb4_unicode_ci/utf8mb4_unicode_ci/g