how can I increase the file size when importing sql file in phpmyadmin?

Discussion in 'PHP' started by etc, Aug 2, 2012.

0
  1. #1
    My localhost server only allow (Max: 2,048 KiB) but my dump file that I wanted to import is about 200mb, how can I increase the file size when importing sql file in phpmyadmin?
     
    Solved! View solution.
    etc, Aug 2, 2012 IP
  2. #2
    Maybe you should try load dump from console ? I don't knot which system you are using, if it is linux try this in terminal :


    You can dump the database into a file using: mysqldump -h hostname -u user --password=password databasename > filename you can restore the info to the database again using: mysql -h hostname -u user --password=password databasename < filename
     
    darl1985, Aug 2, 2012 IP
  3. etc

    etc Well-Known Member

    Messages:
    3,238
    Likes Received:
    30
    Best Answers:
    0
    Trophy Points:
    158
    #3
    Thanks darl. I got it restored. I'm using ubuntu.
     
    etc, Aug 2, 2012 IP
  4. imranamen6

    imranamen6 Active Member

    Messages:
    947
    Likes Received:
    4
    Best Answers:
    1
    Trophy Points:
    98
    Digital Goods:
    1
    #4
    If you have more problem in future use BigDump
     
    imranamen6, Aug 2, 2012 IP