Database Transfer Help Please

Discussion in 'MySQL' started by KIbeth, Jun 18, 2006.

  1. #1
    Im going to buy a hosting package from dreamhosting. Im planning on starting a network. I have a site on another server which i would like to transfer to my new server.
    This site HAs several mysql databass including one for game reviews and one for a SMF forum.
    Is there a way i can transfer these databases to my new server, preferably using cpanel : )
    Help would be very much appericiated!
     
    KIbeth, Jun 18, 2006 IP
  2. bizoppz

    bizoppz Peon

    Messages:
    1,889
    Likes Received:
    49
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Yes, the easiest way would be to use phpMyAdmin to export the DB's and then to import into the new DB's...

    If you would like some assistance, PM me, I would be more than happy to help.
     
    bizoppz, Jun 18, 2006 IP
  3. kartik786

    kartik786 Well-Known Member

    Messages:
    1,906
    Likes Received:
    61
    Best Answers:
    0
    Trophy Points:
    170
    #3
    Hey buddy.. even i want to transfer my vbulletin forum mysql .. ne help wud be appreciated..

    I cannot import and export because the database is huge.. about 500mb and there are session time outs.
     
    kartik786, Jun 18, 2006 IP
  4. bizoppz

    bizoppz Peon

    Messages:
    1,889
    Likes Received:
    49
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I can do it for you, but since it will take a little time, would $20 sound fair to you? I will start moving the databases over as soon as payment via PayPal is received.
     
    bizoppz, Jun 18, 2006 IP
  5. noppid

    noppid gunnin' for the quota

    Messages:
    4,246
    Likes Received:
    232
    Best Answers:
    0
    Trophy Points:
    135
    #5
    There is a way for your host to pull your cpanel account from the old server to the new. Most will do it for ya for free. However, I think the other host may need to cooperate.

    Your old host could do a cpanel backup and let you FTP it home, then FTP it to the new host and ask them to restore it.

    Good luck.
     
    noppid, Jun 18, 2006 IP
  6. designcodes

    designcodes Well-Known Member

    Messages:
    213
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    133
    #6
    I agree your new host can do it for you, just tell them that you will need your site transfered before buying any hosting plan.
     
    designcodes, Jun 26, 2006 IP
  7. Haichi

    Haichi Well-Known Member

    Messages:
    293
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    128
    #7
    yeah I am also looking for help moving a database to dreamhost but its not a forum but a word for word dictionary with search function
     
    Haichi, Jun 27, 2006 IP
  8. kikker

    kikker Well-Known Member

    Messages:
    423
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    110
    #8
    If you use the cpanel in the new and old server, than you can transfer it easily. f that is not the case, than ask the shell access for you hosting, than you can transfer so easily with ssh
     
    kikker, Jun 27, 2006 IP
  9. sadcox66

    sadcox66 Spirit Walker

    Messages:
    496
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Actually you do not need shell access.

    Just login to your cPanel account and select Backup | Backup your site and provide the root from where you want to start a backup.

    You will be able to download a .tar file

    Next go to your new server and select the backup option and
    proceed to Import the .tar file and your site will be restored.

    Make sure your dependencies (php/perl/etc) libraries are the same on both servers.




    Give me some green points if this helps you.
     
    sadcox66, Jun 27, 2006 IP
    Old Welsh Guy likes this.