I have an existing blog that covers 2 topics (one of them adult, the other SFW). I wanted to upload the old blog to a new domain and then go back and edit the posts and delete all the adult content, but when I successfully exported the database and got it installed at the new domain it was more of a snapshot of the old site and every post linked to the old site. I opened the SQL database with notepad and ran a find/replace and changed all instances of the old URL to the new URL but the database restore wouldn't work with the edited file. Both sites hosted at godaddy - just backed up old sites database and uploaded it to new site. It worked BEFORE I tried to change the URL.
Is this possible?