1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Need someone to transfer a large site / DB

Discussion in 'Services' started by aaron_nimocks, Nov 25, 2006.

0
  1. #1
    Ok this is too much for me to handle. The database is a 175 MBish and I cant figure out how to move it.

    Its going from one dedicated server to another.

    Please let me know if you can do this and for how much.
     
    aaron_nimocks, Nov 25, 2006 IP
  2. mikelbeck

    mikelbeck Well-Known Member

    Messages:
    790
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    108
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    Do you have root access on the destination server? You can dump the database with phpMyAdmin from the source server and then import it (from the command line) on the destination server.

    mysql -u database_username -p databasename < dumpfile.sql
     
    mikelbeck, Nov 25, 2006 IP
    aaron_nimocks likes this.
  3. Lpspider

    Lpspider Well-Known Member

    Messages:
    2,216
    Likes Received:
    56
    Best Answers:
    0
    Trophy Points:
    160
    As Seller:
    100% - 0
    As Buyer:
    100% - 1
    #3
    Use SSH to download/restore.
     
    Lpspider, Nov 25, 2006 IP
  4. aaron_nimocks

    aaron_nimocks Im kind of a big deal Staff

    Messages:
    5,563
    Likes Received:
    627
    Best Answers:
    0
    Trophy Points:
    420
    As Seller:
    100% - 1
    As Buyer:
    100% - 0
    #4
    I have root access for both. I just cant figure out how to dump it. Its too big I guess.
     
    aaron_nimocks, Nov 25, 2006 IP
  5. netsinteractive

    netsinteractive Peon

    Messages:
    186
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #5
    ask your new host to transfer free of charge.
     
    netsinteractive, Nov 25, 2006 IP
  6. mikelbeck

    mikelbeck Well-Known Member

    Messages:
    790
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    108
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #6
    On the source server: mysqldump -u database_username -p databasename > dumpfile.sql

    Then copy the dumpfile.sql to the destination server and:

    mysql -u database_username -p databasename < dumpfile.sql
     
    mikelbeck, Nov 25, 2006 IP
  7. aaron_nimocks

    aaron_nimocks Im kind of a big deal Staff

    Messages:
    5,563
    Likes Received:
    627
    Best Answers:
    0
    Trophy Points:
    420
    As Seller:
    100% - 1
    As Buyer:
    100% - 0
    #7
    I did and they transferred all my site except that one. :)

    Basically I went from the slowest dedicated server to the fastest at hostgator and they transferred everything for me but that site. Guess they had problems too.
     
    aaron_nimocks, Nov 25, 2006 IP
  8. aaron_nimocks

    aaron_nimocks Im kind of a big deal Staff

    Messages:
    5,563
    Likes Received:
    627
    Best Answers:
    0
    Trophy Points:
    420
    As Seller:
    100% - 1
    As Buyer:
    100% - 0
    #8
    Thing is I dont know what directory to go to, or even much how to use SSH. Ive read how to do it, but I just cant. :)
     
    aaron_nimocks, Nov 25, 2006 IP
  9. netsinteractive

    netsinteractive Peon

    Messages:
    186
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #9
    I use hostgator too, very helpful people.
     
    netsinteractive, Nov 25, 2006 IP
  10. mikelbeck

    mikelbeck Well-Known Member

    Messages:
    790
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    108
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #10
    PM coming your way...
     
    mikelbeck, Nov 25, 2006 IP
  11. 007

    007 Well-Known Member

    Messages:
    328
    Likes Received:
    30
    Best Answers:
    0
    Trophy Points:
    120
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #11
    Aaron, it's not too hard to use SSH, however if you've never used it before, maybe you should get somebody here to do it for you for a small price?

    I could do it but I'm sure there are other people that you know here who are just as capable. And a word of advice, you SHOULD know how to backup your 178MB database because what would you do if it became corrupt?

    From what I understand you don't know how to back it up either, since that's the first half of moving it.. But really, you should be backing that up daily. You don't want to even think about the headaches of losing all your database data...
     
    007, Nov 25, 2006 IP
  12. sundaybrew

    sundaybrew Numerati

    Messages:
    7,294
    Likes Received:
    1,260
    Best Answers:
    0
    Trophy Points:
    560
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #12
    Good point Z!

    Yea, I have had that happen....Just do a phpadmin export
     
    sundaybrew, Nov 25, 2006 IP
  13. mikelbeck

    mikelbeck Well-Known Member

    Messages:
    790
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    108
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #13
    All fixed! ;-)

    And to whoever red rep'd me for this thread... bite me.
     
    mikelbeck, Nov 25, 2006 IP