Find and replace in a large file

Written by Peter Davies on .

I have a 2Gb database dump that needed the database name changing (remember trailing slash):

cat sql_file | sed 's/olddbname/newdbname/'

and to check that it's complete:

grep olddbname sql_file