WP database help!

M

makinbuckz

Junior Member

Sep 21, 2009

152

33

• Jan 6, 2011

• #1

I used wp db backup to download a database from a site that i wanted to duplicate in another. It looks like i uploaded the db in the php control panel successfully, but when i try to login to the new site, it goes to the old URL and not the new one. Any idea how to change this?

 

S

saraboo

Newbie

Jun 12, 2010

9

3

• Jan 6, 2011

• #2

Might sound like a stupid question but have you checked the wp-config.php file? It may still have the old websites db details in it.

 

G

gerulis

Newbie

Jun 18, 2009

18

2

• Jan 6, 2011

• #3

saraboo said:

Might sound like a stupid question but have you checked the wp-config.php file? It may still have the old websites db details in it.

Click to expand...

thats not it.

in your dbs in wp_options table you should change all entries of your old url to your new one.

 

M

makinbuckz

Junior Member

Sep 21, 2009

152

33

• Jan 6, 2011
• Thread Starter Thread Starter

• #4

gerulis, could you be a little more specific. i appreciate your help!!

 

G

gerulis

Newbie

Jun 18, 2009

18

2

• Jan 6, 2011

• #5

Ok, so you do have access to your mysql db? somethin like phpmyadmin or similar?

if so, you need to access your db and locate wp_options table. open it. browse and edit all entries where you see your old url and replace that with new one.

or alternatively your can run some sql command which will automaticaly do this for you.

or you can open your old blogs database file, search for your old url and replace it with new one.

 

M

makinbuckz

Junior Member

Sep 21, 2009

152

33

• Jan 6, 2011
• Thread Starter Thread Starter

• #6

Ok, i think i got it. One last question...how do i change the username and password for the new blog?

 

G

gerulis

Newbie

Jun 18, 2009

18

2

• Jan 6, 2011

• #7

you'll be able to do that once you login.

 

roberteb

Compromised Account

Oct 30, 2010

549

183

• Jan 6, 2011

• #8

To change user name log in with old details then add a new user and grant admin user rights. Log out and login with new user to verify it's OK and has admin privledges, Then delete old user and you'll be prompted to move all posts / links to new user. Pick the one you've just created and you're good to go.

I aways back up my WP Blog before doing the above - you can't be to careful

 

Last edited: Jan 6, 2011