Problems uploading a large sql database

Discussion in 'Databases' started by www.mazoo.co.uk, Apr 3, 2007.

  1. #1
    I'm trying to upload a sql file around 1gig in size and it keeps stopping around 85meg, i using cuteftp to upload it and have tried uploading it compressed, around 400 meg and it still stop after uploading around 85meg.

    1. any ideas how to upload such a large file?
    2. if i upload it compressed how do i uncompress it once its on the server?

    Please help!!
     
    www.mazoo.co.uk, Apr 3, 2007 IP
  2. frankcow

    frankcow Well-Known Member

    Messages:
    4,859
    Likes Received:
    265
    Best Answers:
    0
    Trophy Points:
    180
    #2
    Can't you use 'resume' in CuteFTP to just resume uploading where it quit?
    Does your host have a file upload limit?
     
    frankcow, Apr 3, 2007 IP
  3. abdulzis

    abdulzis Peon

    Messages:
    31
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Even FileZilla is good freeware FTP client to pause and resume transfers
     
    abdulzis, Apr 3, 2007 IP
  4. Clive

    Clive Web Developer

    Messages:
    4,507
    Likes Received:
    297
    Best Answers:
    0
    Trophy Points:
    250
    #4
    It can be related to your webhosting server settings.
    I managed to upload files over 1,5Gb in the past (SQL dumps also) without an issue.
     
    Clive, Apr 3, 2007 IP
  5. WACMan

    WACMan Peon

    Messages:
    253
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I have used Big Dump in the past with no problems.
     
    WACMan, Apr 3, 2007 IP
    www.mazoo.co.uk likes this.
  6. www.mazoo.co.uk

    www.mazoo.co.uk Peon

    Messages:
    225
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    0
    #6
    i have managed to upload the file and decompress it using cpanel filemanager, im just having problems configuring the bigdump.php file, i have used it before without any problems but it seems its having issues with the database settings.
     
    www.mazoo.co.uk, Apr 3, 2007 IP
  7. www.mazoo.co.uk

    www.mazoo.co.uk Peon

    Messages:
    225
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Ok problems sorted i updated to the latest version of bigdump.php and problems solved. cheers wacman
     
    www.mazoo.co.uk, Apr 3, 2007 IP