Importing massive MySQL databases

Discussion in 'MySQL' started by mines, Aug 10, 2007.

0
  1. #1
    hi,
    everytime i try it through phpmyadmin it times out/gets errors as it takes too long. how can i import "massive" (>50mb nothing TOO big) databases?

    cheers
     
    mines, Aug 10, 2007 IP
  2. killerj

    killerj Active Member

    Messages:
    765
    Likes Received:
    34
    Best Answers:
    0
    Trophy Points:
    95
    #2
    http://www.ozerov.de/bigdump.php
    It works like butter and will definitely help you .
    Good luck.
     
    killerj, Aug 10, 2007 IP
  3. cupid07

    cupid07 Well-Known Member

    Messages:
    128
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    101
    #3
    Or you can just split the database into several smaller databases and upload one at a time. I had the same problem with one of mine ages ago, luckily though (after several failed attempts) it managed to upload without a timeout happening.
     
    cupid07, Aug 11, 2007 IP
  4. nikko999

    nikko999 Peon

    Messages:
    406
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #4
    1)big dump
    2)Upload it to your server and tell you host to do it for you(recommended)
    3)Upload via PhpMyadmin , just upload it ,and when it stops , upload the same file again , it will continue from where it stops
     
    nikko999, Aug 11, 2007 IP