CODEWITHSUNDEEP
grepreplace
saltcod
saltcod

Reputation: 2031

Find and replace a URL with grep/sed/awk?

Fairly regularly, I need to replace a local url with a live in large WordPress databases. I can do it in TextMate, but it often takes 10+ minutes to complete.

Basically, I have a 10MB+ .sql file and I want to:

After that, I'll save the file and do a MySQL import to the local/live servers. I do this at least 3-4 times a week and waiting for TextMate has been a pain.

Is there an easier/faster way to do this with grep/sed/awk?

Upvotes: 3

Views: 13046

Answers (3)

Herson Salinas
Herson Salinas

Reputation: 31

You don't need to replace the http://:

sed "s/localhost:8888/www.my-awesome-page.com/g" input.sql > output.sql

Upvotes: 3

Jared
Jared

Reputation: 1470

sed 's/http:\/\/localhost:8888\/mywebsite/http:\/\/mywebsite.com/g' FileToReadFrom > FileToWriteTo

This is running switch (s/) globally (/g) and replacing the first URL with the second. Forward slashes are escaped with a backslash.

Upvotes: 10

Kent
Kent

Reputation: 195109

kent$  echo "foobar||http://localhost:8888/mywebsite||fooooobaaaaaaar"|sed 's#http://localhost:8888/mywebsite#http://mywebsite.com#g'
foobar||http://mywebsite.com||fooooobaaaaaaar

if you want to do the replace in place (change in your original file)

sed -i 's#http://.....#http://mysite#g' input.sql

Upvotes: 3

Related Questions