1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

WP database help!

Discussion in 'Blogging' started by makinbuckz, Jan 6, 2011.

  1. makinbuckz

    makinbuckz Junior Member

    Joined:
    Sep 21, 2009
    Messages:
    152
    Likes Received:
    32
    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?
     
  2. saraboo

    saraboo Newbie

    Joined:
    Jun 12, 2010
    Messages:
    9
    Likes Received:
    3
    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.
     
  3. gerulis

    gerulis Newbie

    Joined:
    Jun 18, 2009
    Messages:
    18
    Likes Received:
    2
    Occupation:
    Programmer
    Location:
    Lithuania
    Home Page:

    thats not it.

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

    makinbuckz Junior Member

    Joined:
    Sep 21, 2009
    Messages:
    152
    Likes Received:
    32
    gerulis, could you be a little more specific. i appreciate your help!!
     
  5. gerulis

    gerulis Newbie

    Joined:
    Jun 18, 2009
    Messages:
    18
    Likes Received:
    2
    Occupation:
    Programmer
    Location:
    Lithuania
    Home Page:
    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.
     
    • Thanks Thanks x 1
  6. makinbuckz

    makinbuckz Junior Member

    Joined:
    Sep 21, 2009
    Messages:
    152
    Likes Received:
    32
    Ok, i think i got it. One last question...how do i change the username and password for the new blog?
     
  7. gerulis

    gerulis Newbie

    Joined:
    Jun 18, 2009
    Messages:
    18
    Likes Received:
    2
    Occupation:
    Programmer
    Location:
    Lithuania
    Home Page:
    you'll be able to do that once you login.
     
  8. roberteb

    roberteb Regular Member

    Joined:
    Oct 30, 2010
    Messages:
    402
    Likes Received:
    120
    Location:
    UK
    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 :)
     
    • Thanks Thanks x 1
    Last edited: Jan 6, 2011