Find and replace in a large file (Peter Davies)

Blog‎ > ‎

Find and replace in a large file

posted 28 May 2009 00:52 by Peter Davies [ updated 4 Mar 2010 01:59 by Peter Davies ]

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