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.
#1 mysqldump ... > 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.