Find and replace in a large file
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
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