How to transfer wordpress database to another domain

Discussion in 'WordPress' started by falguni1, Apr 2, 2009.

  1. #1
    How to transfer wordpress database to another domain

    I have a wordpress blog and I now want to use another domain name.

    How to transfer the database completely to new domain name.
     
    falguni1, Apr 2, 2009 IP
  2. ThreeGuineaWatch

    ThreeGuineaWatch Well-Known Member

    Messages:
    1,489
    Likes Received:
    69
    Best Answers:
    0
    Trophy Points:
    140
    #2
    ThreeGuineaWatch, Apr 2, 2009 IP
  3. deluxdon

    deluxdon Catch Me If You Can...!!!™ Staff

    Messages:
    25,482
    Likes Received:
    1,943
    Best Answers:
    32
    Trophy Points:
    480
    #3
    Just take 'Home Directory' backup and 'My SQL DB Backup' from your old host and restore it at new host.

    BTW why don't you ask this to do this process to your new hosting provider as they can easily doing this directly from old hosting to their hosting.

    DON.
     
    deluxdon, Apr 2, 2009 IP
  4. omshanti

    omshanti Well-Known Member

    Messages:
    515
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #4
    the hosting provider will charge you at least $50 for the same!

    Hire someone to do it if you don't know how to do it!

    Let me know if you need help! thanks!
     
    omshanti, Apr 2, 2009 IP
  5. AnnAnderson1015

    AnnAnderson1015 Banned

    Messages:
    86
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I'm new to IT, so bare with me. Can you just use a FTP client and copy all of your data onto your comp and then take it to the new host?
     
    AnnAnderson1015, Apr 2, 2009 IP
  6. glitto

    glitto Notable Member

    Messages:
    2,839
    Likes Received:
    185
    Best Answers:
    0
    Trophy Points:
    205
    #6
    glitto, Apr 2, 2009 IP
  7. falguni1

    falguni1 Peon

    Messages:
    3,016
    Likes Received:
    66
    Best Answers:
    0
    Trophy Points:
    0
    #7
    I am not changing my host.

    I only want to change the domain name.
     
    falguni1, Apr 2, 2009 IP
  8. buldozerceto

    buldozerceto Active Member

    Messages:
    1,137
    Likes Received:
    43
    Best Answers:
    0
    Trophy Points:
    88
    #8
    In that case you don't need to transfer the database anywhere. Just copy the wordpress files to another directory and point your other domain to that directory.
     
    buldozerceto, Apr 2, 2009 IP
  9. sarah_harvey

    sarah_harvey Active Member

    Messages:
    703
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    70
    #9
    Yes, all you do is go to your current wordpress admin and then look at the settings. Make a note what your settings are example: Is your Domain listed at http://yourdomain.com or http://www.yourdomain.com (Make a note of this) then go to your other settings like 'writing,' 'reading,' 'discussion,' etc. Make a note of your permalink structure and a few other things. If you have a custom wordpress theme, then make a note of any additional settings you have made for your theme and then once that is done, use a FTP program and download all the files on your host to your hard drive into a folder that you have named after the domain.

    Then enter PHPMyAdmin on your host and export your database to your desktop. It can be uncompressed or in compressed format. Then simply make a note of the username, database username and password and hostname and then proceed to transfer everything to the new domain. Use FTP again to upload all the files and folders you saved in that folder on your desktop and then create a new empty database and populate it with the database information your saved, and last step is to add all the necessary info and make sure that the settings are the same as before.

    Short and quick version.
     
    sarah_harvey, Apr 2, 2009 IP