Replace text with sed

ZBsp: Collation in dump ändern

cat dumpname | sed s/CHARSET=utf8/CHARSET=utf8\ COLLATE=utf8_unicode_ci/ > new_dumpname

zB Collation ändern für dump von mysql8 zu mysql5

sed -i backup-file.mysql -e 's/utf8mb4_0900_ai_ci/utf8mb4_unicode_ci/g'