WordPress - moving from one host to another

Question

I am trying to move a WordPress installation from one server to another one, including all of the SQL data, and the file-system data (photos,template files).

I just have a problem changing the URLs in the database, since I need to replace the new URL with the old one.

I would love to have some suggestions about how can I replace the URLs (maybe there's a rplace statement in SQL?)

Thanks in advance.

Answer 1

There is indeed a REPLACE() function in MySQL, but I would recommend doing what hsatterwhite suggests and editing the whole MySQL dump as a flat file before re-importing, not least because the REPLACE() function is case sensitive.