how to import old database to new one, with different url?

Discussion in 'Databases' started by codemaster89, Mar 28, 2012.

0
  1. #1
    hey all, today i was trying to import an old database to my new website, but when i upload it, the url of the website changes, exemple:if the site was of the old database was www.xxxxxxx.com and new site is www.yyyyy.com when i import the database to yyyyy.com and i type it in search bar, it redirects me to xxxxx.com so i have to change the url from the database to let him go in the correct site, how do i do this?i got access to myphpadmin, but dont have a clue on how to do it, please some1 help thanks
     
    codemaster89, Mar 28, 2012 IP
  2. codemaster89

    codemaster89 Member

    Messages:
    65
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    25
    #2
    ok well i found something, this is kinda impossible to tryed to change urls in sql, but what is the command?i got a command to change it in 1 table but how do i change on all tables?
     
    codemaster89, Mar 28, 2012 IP
  3. ShinoRex

    ShinoRex Well-Known Member

    Messages:
    227
    Likes Received:
    9
    Best Answers:
    2
    Trophy Points:
    148
    #3
    Hi did you got someone to do this? If no. Then I'm ready... Please Pm me..
     
    ShinoRex, Apr 12, 2012 IP
  4. tiffanywilliams12i2

    tiffanywilliams12i2 Peon

    Messages:
    164
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    are you using phpmyadmin? you can also ask your host to help you
     
    tiffanywilliams12i2, Apr 12, 2012 IP
  5. codemaster89

    codemaster89 Member

    Messages:
    65
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    25
    #5
    well actualy, tryed everything to make this work, and found that ITS NOT POSSIBLE if you dont have access to the old url/admin panel of the site on the old url.so kinda wasted time
     
    codemaster89, Apr 16, 2012 IP
  6. abdurrahman

    abdurrahman Greenhorn

    Messages:
    67
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #6
    Download Simple Search and replace keep the sql file in a folder. You can then mass replace the text in the database with single click
     
    abdurrahman, May 16, 2012 IP
  7. alexo

    alexo Well-Known Member

    Messages:
    372
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    108
    #7
    Agry with abdurrahman try to search and replace in text editor, also pls check your htaccess file :)
     
    alexo, May 21, 2012 IP