how to import 10mb+ file to database ?

Discussion in 'MySQL' started by strings, Apr 9, 2008.

0
  1. #1
    hello


    Just facing the problem ... i want to import a file of size 10 mb ..... but the maximum size limit in phpmyadmin is 2mb .

    So is there any other simple way i can import the database ?.


    CHeers
     
    strings, Apr 9, 2008 IP
  2. pngseo

    pngseo Banned

    Messages:
    212
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #2
    pngseo, Apr 9, 2008 IP
  3. vagrant

    vagrant Peon

    Messages:
    2,284
    Likes Received:
    181
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I use a php script called BigDump from http://www.ozerov.de/bigdump.php


    Works fine for me.
     
    vagrant, Apr 9, 2008 IP
  4. maxelll3752

    maxelll3752 Peon

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I think your host can import it for you, most times they have cpanel setup to only allow an x file size.
     
    maxelll3752, Apr 11, 2008 IP
  5. komirad

    komirad Well-Known Member

    Messages:
    921
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    108
    #5
    You can try using sql through phpmyadmin?
     
    komirad, Apr 12, 2008 IP
  6. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #6
    Strings,
    It depends in which environment you are. If you are using a shared hosting account then you might need your host help. But if you have total control over your server then you have a lot of options like pngseo given you have a link to another thread.
     
    mwasif, Apr 12, 2008 IP
  7. Whippet75

    Whippet75 Well-Known Member

    Messages:
    1,599
    Likes Received:
    23
    Best Answers:
    0
    Trophy Points:
    155
    #7
    Use a web-based mysql import script.
     
    Whippet75, Apr 12, 2008 IP
  8. Farhan5

    Farhan5 Peon

    Messages:
    189
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #8
    i think sql can do it...
     
    Farhan5, Apr 13, 2008 IP
  9. nastynappy

    nastynappy Banned

    Messages:
    499
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #9
    the best option is to use bigdump.php
    it is free, and very good, I have used it many times, but currently I dont have it on my pc
    try google to find it.
     
    nastynappy, Apr 13, 2008 IP
  10. adda4u

    adda4u Well-Known Member

    Messages:
    1,003
    Likes Received:
    40
    Best Answers:
    0
    Trophy Points:
    160
    #10
    Place a request to ur host people they will do it

    i am sure ...
     
    adda4u, Apr 13, 2008 IP
  11. valipe

    valipe Member

    Messages:
    43
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #11
    You can do it by splitting table entries you can export them
     
    valipe, Apr 16, 2008 IP