删除或替换错误的字符串

Question

I have a sql dump with incorrect URLS.

Text stuff goes here before the url <a href="http://www.incorrectsite.com/incorrecturl/2000/xxx/yyy/zzz.html>Correct Text</a>

In the correct urls

Another text stuff goes here. <a href="http://www.correctsite.com/correctsite/uploads/2000/xxx/yyy/zzz.html>Correct Text</a>. And here too.

I am required to remove incorrect url and clean up the SQL dump.

I can find the records using,

select * from tbl_incorrect WHERE like '%incorrecturl%'

Each returning value for the URLs are different from each other.

Any thoughts?

Answer 1

You can open dump into vim and replace all URLs:

:%s/www.incorrectsite.com\/incorrecturl/www.correctsite.com\/correctsite\/uploads/g
:wq

or use sed:

sed 's/www.incorrectsite.com\/incorrecturl/www.correctsite.com\/correctsite\/uploads/g' incorrect.sql > correct.sql