Transfering Blog - Lost blog after sql database backup and export WordPress

Svilen Popov answers:

Did you change DNS servers ?

Rashad Aliyev answers:

You should edit .sql for new servers.

wjm answers:

I have dealt with this several times.


you need to add
define('RELOCATE',true);
to your wp-config.php

to avoid getting redirected.

the thing is, you will have to upload every single link in your dataabase, that is images and internal links from your old domain to your new..
not an easy search and replace in your db export, since data is serialized and if your new domain has a different lenght than the old, it will just not work and corrupect your data.

I have modified a script to do this update.
http://wordpress.pastebin.com/deRAxdWV

1. save it in your main folder (same folder wp-config.php is) as searchreplacedb.wjm.php
2. replace
'olddomain.com', //Old domain
with whatever your olddomain was. (including www if you used that, but dont include http://)

3. Back up your database (This is very important).

4. run this script by visiting newdomain.com/searchreplacedb.wjm.php

5. remove define('RELOCATE',true); from wp-config.php

and you should be good.

PD: if you dont want to deal with all this i can do it for you for a small additional fee.

wjm comments:

sorry, i thought you were moving domains,
forget the answer above.