How do I transfer mysql databases?

Discussion in 'MySQL' started by MarktheDude, Aug 25, 2009.

  1. #1
    I have created a mysql database of my site and I need to install it on another server but I am having issues.

    I don't want to go into detail about my issues, I would rather just have someone tell me how I suppose to transfer databases.

    I want to start fresh so just tell me from step one I guess.

    Thanks!
     
    MarktheDude, Aug 25, 2009 IP
  2. crivion

    crivion Notable Member

    Messages:
    1,669
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    210
    Digital Goods:
    3
    #2
    if you have the mysql dump just go into phpmyadmin and import it
    if it's too large, try using bigdump.php
     
    crivion, Aug 25, 2009 IP
    Hoster1 likes this.
  3. graformix

    graformix Member

    Messages:
    92
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #3
    Try to google for any of 3-rd party tools which will guide you through the conversion process
     
    graformix, Aug 26, 2009 IP
  4. kane4545

    kane4545 Guest

    Messages:
    99
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Take backup using phpmyadmin and save it as sql file and restore it on your new server
     
    kane4545, Aug 26, 2009 IP
  5. Sparkydude31809

    Sparkydude31809 Peon

    Messages:
    688
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #5
    This works well I just tried it lol =p
     
    Sparkydude31809, Sep 1, 2009 IP