increase database maxsize

Discussion in 'MySQL' started by fasafeso, Oct 1, 2010.

  1. #1
    I got some problem with importing database !!!!
    I need to import database with size 250MB and phpmyadmin didn't allow me to import database with size bigger than 80MB !!!
    and this database in one peace that's way I can't discrete this database !!!!
    so what to do please help !!! as fast as possible !!!!
     
    fasafeso, Oct 1, 2010 IP
  2. RHS-Chris

    RHS-Chris Well-Known Member

    Messages:
    1,007
    Likes Received:
    35
    Best Answers:
    10
    Trophy Points:
    150
    #2
    Talk with your host and have them import the database via command line, it will go in very quickly. If you have ssh access, just let me know, and I can tell you how to do it.
     
    RHS-Chris, Oct 1, 2010 IP
  3. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #3
    The easiest option is to seek the help of your host, and to do it yourself is through command line if you have ssh access as RHS-Chris replied earlier. If you can't use any of the above options then your option is using bigdump.
     
    mwasif, Oct 7, 2010 IP