Ask your WordPress questions! Pay money and get answers fast! Comodo Trusted Site Seal
Official PayPal Seal

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

  • SOLVED

Had a blog hosted on godaddy and i backed it up as the sql according to directions in a transfer instruction. Blog is currently not showing up at old domain and needs to be on a different server with the same url. have loginandpassword for both accounts.

Answers (4)

2010-07-22

Oleg Butuzov answers:

[email protected]
msg me


Oleg Butuzov comments:

Brook, blog transfered.

Was nice to help you again.

2010-07-22

Svilen Popov answers:

Did you change DNS servers ?

2010-07-22

Rashad Aliyev answers:

You should edit .sql for new servers.

2010-07-22

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.