Using sed to replace URL

Question

I'm having some trouble using sed to replace a string in an sql file. So far I have:

sed -i 's#http://mydomainurl.co.uk#http://pinkiepie#g' /home/user/dbs/my_database.sql

Whenever I run this it does remove http://mydomainurl.co.uk but replaces it with http://pinkiepie.co.uk The local machine at home is called pinkiepie, so doesn't need a TLD .co.uk suffix, so it should replace it with http://pinkiepie

Any idea where I'm going wrong here?

Answer 1

sed -i 's,http://localhost:3000/,https://anywebsite.io/,g' ./destination

most easy solution