Huge Mysql Database with godaddy

Discussion in 'MySQL' started by niravdave, Dec 17, 2008.

0
  1. #1
    Hi Guys,

    I have a wordpress database which is 112 MB in .gz format. I was trying to import it on Godaddy Shared Hosting using www.ozerov.de/bigdump.php, but i keep getting the memory exhausted error. I know the solution is to switch hosting or buy dedicated server, but i have several sites hosted there and i cannot afford a server.

    Is there a solution to import this wordpress database on godaddy using another cpanel hosting? I have a spare cpanel hosting but that is already hosting a site.

    help appreciated.

    cheers!
    nirav
     
    niravdave, Dec 17, 2008 IP
  2. Colbyt

    Colbyt Notable Member

    Messages:
    3,224
    Likes Received:
    185
    Best Answers:
    0
    Trophy Points:
    210
    #2
    You can always open the file on you local computer and cut it down to smaller seperate querys and then import those.

    As long as you start and stop where insert section ends you will be fine. It is one heck of a lot of work but it will do the job.

    If you still have it on a server somewhere you can export one table at a time and do the same thing without all the manual labor.
     
    Colbyt, Dec 17, 2008 IP
  3. crivion

    crivion Notable Member

    Messages:
    1,669
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    210
    Digital Goods:
    3
    #3
    How do you import the database ? Are you browsing for it locally or first upload it do bigdump ftp directory?
     
    crivion, Dec 17, 2008 IP
  4. israelibadamm

    israelibadamm Greenhorn

    Messages:
    17
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #4
    There is a software online called Big Dump, all you have to do is upload the bigdump.php (after you modified it to fit your data) with the SQL file and it will do the rest for you.

    I would post a link but I'm not sure about the forum rules, just Google it, it's free

    Best
    Yossi
     
    israelibadamm, Dec 17, 2008 IP
  5. niravdave

    niravdave Active Member

    Messages:
    675
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    88
    #5
    the unzipped sql file is 300MB. and godaddy doesnt allow more then 2mb at a time. hell lot of work. but thanks for your advice.

    uploading it to the directory.
    did you even read my first post?
     
    niravdave, Dec 17, 2008 IP
  6. shenron

    shenron Notable Member

    Messages:
    4,965
    Likes Received:
    374
    Best Answers:
    0
    Trophy Points:
    295
    #6
    You can post a link without a problem (no affiliates) and you can also PM the link. ;)
     
    shenron, Dec 17, 2008 IP
  7. bille

    bille Peon

    Messages:
    269
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #7
    VPS servers aren't that expensive anymore. Linode.com is $19.95/month for 360MB memory / 12GB disk.

    Made a huge difference in performance for me when I moved from a shared hosting environment.

    But, sounds like you aren't ready for that...

    You might consider bumping up the allocated memory in your php.ini file.
    memory_limit=36M ( or whatever ).

    What is the file format ? The php extension makes it sound like a self-contained script. You might ask if you can get it in mysqldump format. That format is fairly easy to hand edit into smaller chunks.
     
    bille, Dec 17, 2008 IP
  8. articledirectory

    articledirectory Peon

    Messages:
    1,704
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Hello Buddy,
    If bigdump isnt working and you still have the db uploaded on the server you could try installing mysqldumper and import it through that.
    http://forum.mysqldumper.de/downloads.php?cat=2
     
    articledirectory, Dec 18, 2008 IP