Large databases

Discussion in 'Databases' started by Demeant0r, Nov 20, 2007.

0
  1. #1
    Hi,

    I have some large SQL databases I would like to import into my empty databases, it's over 100MB big, phpMyAdmin will only import databases that are up to 50MB big...
     
    Demeant0r, Nov 20, 2007 IP
  2. Kynlem

    Kynlem Peon

    Messages:
    14
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Check out mysqldump
     
    Kynlem, Nov 20, 2007 IP
  3. Kuldeep1952

    Kuldeep1952 Active Member

    Messages:
    290
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    60
    #3
    Use bigdump from ozerov.de/bigdump.php.

    It is a php script which will help you get around the problem
    of the large db size.
     
    Kuldeep1952, Nov 20, 2007 IP
  4. Nick1337

    Nick1337 Peon

    Messages:
    81
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I have used bigdump alot of times, recommended.
     
    Nick1337, Nov 22, 2007 IP
  5. stillo

    stillo Peon

    Messages:
    42
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Do you have SSH access? it is very easy to import via SSH. My database is about 500MB, it took about 3-5 minutes to import. I did not see any problem after restoring.
     
    stillo, Nov 23, 2007 IP
  6. linkmanager

    linkmanager Well-Known Member

    Messages:
    2,432
    Likes Received:
    113
    Best Answers:
    0
    Trophy Points:
    135
    #6
    I agree I'm using same :)
     
    linkmanager, Nov 23, 2007 IP
  7. PowerExtreme

    PowerExtreme Banned

    Messages:
    2,118
    Likes Received:
    75
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Use bigdump or ssh
     
    PowerExtreme, Nov 24, 2007 IP
  8. ForgottenCreature

    ForgottenCreature Notable Member

    Messages:
    7,473
    Likes Received:
    173
    Best Answers:
    0
    Trophy Points:
    260
    #8
    Do you have shell (SSH) access?
     
    ForgottenCreature, Nov 24, 2007 IP
  9. zonzon

    zonzon Peon

    Messages:
    100
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #9
    you'll need a SSH access and use mysqldump & restore the dump after.... that's the only way I know, because I always use this one
     
    zonzon, Nov 24, 2007 IP
  10. X0G

    X0G Peon

    Messages:
    32
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #10
    Bigdump works like a charm, my database is far over 200 gb too
     
    X0G, Nov 24, 2007 IP