help opening and uploading a large database

Discussion in 'MySQL' started by movingconcierge, Oct 3, 2008.

0
  1. #1
    Hi folks. I'd appreciate your help. I have a large database 612,000 kb. My host account only allows imports of 50,000 kb and under. I went to open up the sql database dump, but no programs could handle it. Does anyone have any assistance to offer? Rep and my thanks in return.
     
    movingconcierge, Oct 3, 2008 IP
  2. lenney

    lenney Well-Known Member

    Messages:
    462
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    103
    #2
    hello i recently opened a database over 600mb in notepad and uploaded manually u can add me for more info lenney2k7@hotmail.co.uk
     
    lenney, Oct 3, 2008 IP
  3. chisara

    chisara Peon

    Messages:
    141
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Assuming your assusing Mysql as your databse server and you are using something like phpmyadmin.

    Altough I have not used it myself, maybe this can be of assistance.
    http://www.ozerov.de/bigdump.php
     
    chisara, Oct 3, 2008 IP
    movingconcierge likes this.
  4. kind_of_the_cash

    kind_of_the_cash Active Member

    Messages:
    852
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    85
    #4
    contact me I can help you but where is your host ?
     
    kind_of_the_cash, Oct 3, 2008 IP
  5. movingconcierge

    movingconcierge Well-Known Member

    Messages:
    550
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    110
    #5
    Thanks for the bigdump :p it worked like a champ!
     
    movingconcierge, Oct 4, 2008 IP
  6. Bohra

    Bohra Prominent Member

    Messages:
    12,573
    Likes Received:
    537
    Best Answers:
    0
    Trophy Points:
    310
    #6
    bigdump is good.. But ssh is the best and fastest for doing this
     
    Bohra, Oct 4, 2008 IP
  7. chandan123

    chandan123 Prominent Member

    Messages:
    11,586
    Likes Received:
    578
    Best Answers:
    0
    Trophy Points:
    360
    #7
    ssh is good but all host wont give ssh access
     
    chandan123, Oct 4, 2008 IP
  8. chisara

    chisara Peon

    Messages:
    141
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Which in my humble opinion is the root cause of the problem, bigdump is good as a solution for the symptoms.
    The best advice when one is looking for a hoster is to check for shell access, when you are already "married" with a specific hosting provider then bigdump is the second best thing :) Since you ussually can't just pack up and leave.

    Cheers,
     
    chisara, Oct 4, 2008 IP
    chandan123 likes this.