BigDump question

Discussion in 'MySQL' started by easypp, Feb 7, 2008.

0
  1. #1
    I have a question...I'm trying to transfer a large database(100MB) to my host server, and I'm using BigDump to do it. Roughly, how long will it take to be completed. The reason why I ask, is I've been waiting for 2 hours now, I didn't think it would take that long. And there are no error messages coming up on my browser either.

    Thank You
     
    easypp, Feb 7, 2008 IP
    ash1ey likes this.
  2. SoKickIt

    SoKickIt Active Member

    Messages:
    305
    Likes Received:
    30
    Best Answers:
    0
    Trophy Points:
    70
    #2
    If you have SSH access to your server, it shouldn't take more than a couple of minutes.
     
    SoKickIt, Feb 7, 2008 IP
  3. easypp

    easypp Active Member

    Messages:
    126
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #3
    The server I'm using is from hostgator, and from what I understand, they do not support SSH access...Do you know of any other server service that allows this?
     
    easypp, Feb 7, 2008 IP
  4. easypp

    easypp Active Member

    Messages:
    126
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #4
    I'm sorry to keep asking questions about this, but I'm a newbie...

    I've been granted SSH access and given the port number. So I downloaded PuTTY, and connected to the server. From what I've researched I open the database file using this statement.

    mysql -u username -p password Databasename< /home/xxxxxxx/public_html/xxxxxxxx.sql.gz

    which I've done. But then when I use Bigdump, I get no error messages, but nothing seems to be happening...

    What am I missing here?


    Thank You
     
    easypp, Feb 8, 2008 IP
  5. riya_senk

    riya_senk Well-Known Member

    Messages:
    2,014
    Likes Received:
    174
    Best Answers:
    0
    Trophy Points:
    160
    #5
    Well I have used BigDump on hostgator too but never had problem. It might take time because file name is too long. Try to rename it in short names like "test.sql" and it might get solved. If its still not fixed then PM me i will try to dump remotely.
     
    riya_senk, Feb 9, 2008 IP
    easypp likes this.