There are many ways to skin a cat but some are more painful:-)

A simple search & replace on the mysql dumpfile should do this - the easiest way, really:

sed -i.BAK 's/OLD_DOMAIN/NEW_DOMAIN/g' dumpfile, then drop the database, recreate and import the dumpfile.

No?

On Tue, Jun 19, 2012 at 12:46 PM, Nd'wex Common <flexycat@gmail.com> wrote:
You could also google for a file called searchandreplace.php used to search and replace any phrase you would like on your website


On Fri, Jun 15, 2012 at 4:13 PM, Jeremy Ogembo <jeremyogembo@googlemail.com> wrote:
A simple search and replace on the mysqldump file using vim worked for me.


On Tue, Jun 12, 2012 at 10:54 AM, Martin Gicheru <martin@techweez.com> wrote:


On Tue, Jun 12, 2012 at 8:20 AM, Paul M <jpaulmuseeh@gmail.com> wrote:
Dear Martin,


This is a problem with absolute url reference in Wordpress.

However, there is a solution to this issue.

Just log in to the server and enter into the Mysql. Select the db for
your wordpress site and issue the following commands:



1) UPDATE wp_options SET option_value = replace(option_value,
'http://www.old-domain', 'http://www.new-domain') WHERE option_name =
'home' OR option_name = 'siteurl';


2) UPDATE wp_posts SET guid = replace(guid,
'http://www.old-domain','http://www.new-domain');



NB:

Replace 'old-domain' with the initial domain where the website was
pointed to, and 'new-domain' with the current domain name


My m-pesa number is 0723...... for the services rendered.





Regards,

JP


On Mon, Jun 11, 2012 at 9:52 PM, Martin Gicheru <martin@techweez.com> wrote:
> Evening skunks,
> I succeeded moving the wordpress site from the old domain to the new one,
> however, I cant quite figure where I need to edit so as to get all theme
> files to read as they would in site, that is, the login site goes to old
> domain. Anyone know the way around?
>
> --
>
> Regards,
>
> Martin Gicheru|Business Development|Techweez Solutions
>
> Email
> ID: martin@techweez.com | Tel:254721906171 | Website:http://www.techweez.com |
>
> Skype ID: martingicheru | Twitter ID:martingicheru |
>  Gtalk: martin@techweez.com
>
>
>
>
> _______________________________________________
> Skunkworks mailing list
> Skunkworks@lists.my.co.ke
> ------------
> List info, subscribe/unsubscribe
> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
> ------------
>
> Skunkworks Rules
> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
> ------------
> Other services @ http://my.co.ke

Thanx Paul, I slept over it googling and figured out a way to edit that in the config file, using several options 

http://codex.wordpress.org/Changing_The_Site_URL


--

Regards,

Martin Gicheru|Business Development|Techweez Solutions

Email ID: martin@techweez.com | Tel:254721906171 | Website:http://www.techweez.com |

Skype ID: martingicheru | Twitter ID:martingicheru |  Gtalk: martin@techweez.com




_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke



--
In Essentials, Unity; In Non-Essentials, Liberty; but in all things, Charity.


_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke


_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke



--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254733744121/+254722743223
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
I can't hear you -- I'm using the scrambler.