WordPress.org

Ready to get started?Download WordPress

Forums

how to move mysql database to new domain (17 posts)

  1. girlwonder
    Member
    Posted 10 years ago #

    can some brilliant, charming and smart person tell me how to move my database from one domain to another? also, let it be known that i'll need the "for dummies" instructions.

  2. noahpb
    Member
    Posted 10 years ago #

    Girlwonder, are you moving your database from one server to another? The way I have done that in the past is by using mysqldump to creat a file that contains the data in the database and also the info needed to recreate the database on the new server. You then copy that file to the new server using ftp or scp or something similar and then recreate the database on the new server with that file.
    If you can provide some more details about what you are trying to do I could probably give you better instructions.

  3. unoamigo
    Member
    Posted 10 years ago #

    Changing domain name, or location of server?
    A domain name, you will just need to change the settings in WordPress to use the new domain name/location. Course, until your DNS servers update this could cause you some trouble - but only for a day or two.
    Changing servers... wrote something on that earlier. Lets see...
    http://wordpress.org/support/9/6801

  4. girlwonder
    Member
    Posted 10 years ago #

    so essentially i would just move the files to the new domain ftp or do i need to do a clean install? i'm not moving to a different location within the same name but to a completely different domain.

  5. unoamigo
    Member
    Posted 10 years ago #

    Ok, I'm still confused. Domain ie: www.girlwonder.com to www.unoamigo.com?
    Or a different file server. For instance, the two domains above can be hosted on the exact same file server. They can even reference the exact same files.
    So are we just changing the domain name girlwonder.com vs unoamigo.com, or are we storing the files on a new, different physical server?
    Am I making sense, or sounding stupid? ;-)

  6. girlwonder
    Member
    Posted 10 years ago #

    LOL...i don't know - just blame me, i could perhaps be delirious. from girlwonder.org to aroundthewaygirl.org is where i'm going. they are on the same server at my host (bloghosts) - so i think that's what you're saying right?

  7. OperaManiac
    Member
    Posted 10 years ago #

    if they are on the same host i believe the same database should work in the new domain. but confirm that with ur host. ofcourse this works only if u keep the old domain alive.

  8. girlwonder
    Member
    Posted 10 years ago #

    sushubh - i THINK i understand what you're saying and the domain will be alive for quite some time. BUT, is there no way to just move the database altogether to the new domain in the event that i want to park the old one? and if i leave it on the old database, won't my settings tell it to write to the old site? does that make sense? sorry is this complicated as all hell.

  9. girlwonder
    Member
    Posted 10 years ago #

    :( ANYONE? ANYONE?

  10. Anonymous
    Unregistered
    Posted 10 years ago #

    Talk to the company that is hosting your site. First, you can keep the database where it located. Most likely your isp gave you ip to point to mysql database. Even if you shot your domain, it should still work.
    Example:
    let say i have domain bob.com, database point to 205.34.56.78. I move to bobjoe.com, i can still point my bobjoe.com to 205.34.56.78 for mysql database.
    Again, you have to talk to your isp and explain to them what you are trying to do. for wp, all you have to is copy all your files to the new domain.
    hope this help.

  11. noahpb
    Member
    Posted 10 years ago #

    You will also need to change the "WordPress address" and 'Blog address" under General Options (in v1.2).

  12. girlwonder
    Member
    Posted 10 years ago #

    LOL....i'll submit a ticket to my webhost - i'm sure they can figure it out. thanks guys.

  13. girlwonder
    Member
    Posted 10 years ago #

    I found the following instructions, do you guys think that they would work to do what i was asking about above? and if yes, would all i have to be to upload the files for wp or would i have to do a whole install?
    The following are the steps to Export and then Import a MySQL database usnig phpMyAdmin
    Export from phpMyAdmin
    Open cPanel and open your phpMyAdmin
    On the welcome screen you will see an Export option click on this link
    This will bring up the view dump (schema) of databases screen
    Select the tables you wish to be exported from the list
    Ensure you choose SQL as the option (this will alow you to just paste the SQL for your next host)
    It will create text file on the screen, highlight the information and paste it into a text document. Save this for when you get hosting.
    Import to phpMyAdmin
    Open cPanel and open your phpMyAdmin
    On the welcome screen you will see an Query window option (lower left corner) click on this link
    Paste the contents of the text file that you exported and done. Your database and it's contents are moved.
    -------

  14. unoamigo
    Member
    Posted 10 years ago #

    Yep, thats it. That will do you good.
    Be sure to change your "WordPress address" and "Blog address" via wp-admin, otherwise things wont work right. ;-)

  15. girlwonder
    Member
    Posted 10 years ago #

    i'm SOOO going to write a wiki on this - b/c i'm feeling like a genuis right about now. BUT, before i go getting all badass - you guys said to change my site url in the admin - where about? what file needs to be updated?

  16. girlwonder
    Member
    Posted 10 years ago #

    nevamind - i figured it oud

  17. aaron1728
    Member
    Posted 9 years ago #

    are these instructions still good for 1.5?

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.