Batch replace text in big files

For example: Change Collation in a big database dump.

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