title: Find and replace a URL with grep/sed/awk?
body: <p>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. </p>
  
  <p>Basically, I have a 10MB+ .sql file and I want to: </p>
  
  <p>Find:   <a href="http://localhost:8888/mywebsite" rel="nofollow">http://localhost:8888/mywebsite</a></p>
  
  <p>and</p>
  
  <p>Replace with: <a href="http://mywebsite.com" rel="nofollow">http://mywebsite.com</a></p>
  
  <p>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? </p>
  
  <p>Thanks!</p>
  
  <p>Terry</p>