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

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?

---

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

---

Try:

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

---

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