How do I upload a mysql bigger then my host allows?

Discussion in 'Databases' started by Boozedads, Sep 1, 2011.

  1. #1
    Hello i recently bought a site, and I neeeeeed to get the mysql up as its getting tons of traffic but been down for some days. The database is 15k mb and i need to get it down to 2k mb. please help. +rep ifyou can figure this out for me ty.
     
    Boozedads, Sep 1, 2011 IP
  2. jonathon

    jonathon Well-Known Member

    Messages:
    523
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    110
    #2
    Staggered import of large and very large MySQL Dumps (like phpMyAdmin 2.x dumps) even through the web servers with hard runtime limit and those in safe mode. The script executes only a small part of the huge dump and restarts itself. The next session starts where the last was stopped.

    Just use Bigdump and upload the database to your ftp.

    download:
    http://www.ozerov.de/bigdump.zip
     
    jonathon, Sep 1, 2011 IP
  3. Boozedads

    Boozedads Well-Known Member

    Messages:
    132
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    123
    #3
    Do you have gchat? i was wondering if you could walk me through it
     
    Boozedads, Sep 1, 2011 IP
  4. mmerlinn

    mmerlinn Prominent Member

    Messages:
    3,197
    Likes Received:
    819
    Best Answers:
    7
    Trophy Points:
    320
    #4
    Are you asking how to put a 15mb db on a host that only allows a maximum 2b db? Or are you asking how to put a 15mb db on a host that only allows a maximum 2mb upload?

    The answer to the first question is to change hosts or upgrade your host. The answer to the second question is to split the db into smaller chunks.
     
    mmerlinn, Sep 2, 2011 IP
  5. zikoo

    zikoo Greenhorn

    Messages:
    36
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #5
    If u need , i can upload sql for you. Free. :)
     
    zikoo, Sep 8, 2011 IP