Moving a MySQL DB?

Discussion in 'MySQL' started by igvsystems, Jan 4, 2010.

0
  1. #1
    I have a DB on GoDaddy and I want to move it to an other host.

    Can I take the back-up of the DB and Restore it to a MySQL on another host?
     
    igvsystems, Jan 4, 2010 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Yes, you can do that. Export your database using phpMyAdmin and import it phpMyAdmin on the other host.
     
    mwasif, Jan 6, 2010 IP
  3. igvsystems

    igvsystems Peon

    Messages:
    18
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Thanks, it worked great. I'm a MSSQL developer, but I'm really liking mySQL and PHP Admin. Nice and easy to use.
     
    igvsystems, Jan 10, 2010 IP
  4. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #4
    MySQL is really easy to work with. There are also many front end tools available for MySQL as an alternative to phpMyAdmin.
     
    mwasif, Jan 10, 2010 IP
  5. igvsystems

    igvsystems Peon

    Messages:
    18
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    The MySQL went great, however it was a wordpress intall I was moving and that did not go to well. but that is a post for another forum.

    Moving word press is a little more tricking then move files, move db, change connection string.
     
    igvsystems, Jan 12, 2010 IP