What to change at mySQL database for Wordpress move?

I got a blog, which now want to move to another server. But when I import the database, and copy the whole content to a new server, that seems the topic point to the old domain.

What operation should I do to make this right again.

Thx

 

Did u change the domain in Wordpress Option ?. Edit the Db try to find ur old domain name and replace it with your new domain name.

 

Yes, I did change to new url in WP option, but the hardest part is how to change in my sql? Plz instruct me.

 

any help plz

 

if your using cpanel, you can go to phpmyadmin and look for the database your blog is using, go to the settings table and edit the fields you like. best of luck.

 

Any SQL script then to do a quick replace for old url?
thx

 

I think the old server and the new server "must be" same , becuase
you back up old data and restore the old data to new server , so it should be same.

are you change setting on "wp-config.php" ?

 

like chapicha said in the wp-config.php make shure you edited the mysql info and in the options tab in wp (or settings table) change the domain for your blog to your new url

 

Yes, I did. The problem is when you click to view the thread, it will bring you to the old link, which remains in the database I guess. Anyways, there's a solution is to redirect in .htaccess, but what to change in the database to effect this?

 

have u changed the domain or the servers .......i m confused. .. plz mention it :-S

 

Both! Any suggestion?

 

I think you have problem in uniqueurl in posts... your old database url is inside.

What to do, simple thing:
open database with notepade or any other good editor if your in linux gphpedit is best and then just search your old domain and replace with new new domain... gphpedit have option replace all so its handy if you have 10 000 replaces.

 

I guess the url is relative not absolute.

 

Go to PhpMyAdmin -> YourDB -> wp_options -> siteurl (under option_name )
Change siteurl value to your new domain url.
Do the same for home value (PhpMyAdmin -> YourDB -> wp_options -> home)

 

did this work for you. i am having the same problem.

 

Yes, it did man.