How to update all hyperlinks which are in the content Hello I am using book_copy module for creating a new version of the book so i have copied a book which is having more than 1000 pages with the book copy module.
Now the new book copy has all working links but for the new book i needed the new urls.
like for previous book it was content/2012 now i needed content/2013 which i have done with pathauto but problem is that while copying a book it takes url for pages as content/2013 but in the page there are hyperlinks which are not updated and pointing to old book pages.
 So let me know if any module for fixing this issue o/w i need to go on each link and update it which is really a difficult task.
Export the database, run a find and replace over the dumped sql and re-import it.

e.g.:

#1 mysqldump ... &gt; output.sql
#2 copy output.sql to output_mangled.sql as a backup
#3 perl -pi -e 's/content\/2012/content\/2013/' output.sql  
#4 cat output.sql | mysql ...


Replacing ... with authentication and database specification parameters.

To be safer, make the regular expression in the replacement step more specific.