Replace text from a MySQL dump using cat (or something else) in shell

Question

I've got a database dump in MySQL where I want to replace ocurrencies of paths that are in the dump as plaintext.

In this particular case I'd like to replace:

/var/www/

for

/home/www/

How could I safely do that using cat or any other shell tool?

Answer 1

cat old.file | sed 's%/var/www/%/home/www/%g' > new.file

Answer 2

Try:

sed 's/\/var\/www\//\/home\/www\//' old_file > new_file

Answer 3

awk '{gsub("/var/www/","/home/www/")}1' mydump >temp && mv temp mydump