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.

Problems uploading a large sql database

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

0
  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