Increase import limit from 16384 Kib

Discussion in 'MySQL' started by vinpkl, Apr 8, 2015.

0
  1. #1
    Hi
    I want to import 4MB sql file into Phpmyadmin in xampp

    But on import page the limit is to 16384 Kib

    see screenshot

    http://s30.postimg.org/5tkeybnu9/16kib.gif

    How can i increase this limit ??

    In Xampp/php/php.ini i have already set

    post_max_size = 128M

    upload_max_filesize = 128M

    Does anyone has a solution to this problem ??

    Thanks
    Vineet
     
    vinpkl, Apr 8, 2015 IP
  2. PoPSiCLe

    PoPSiCLe Illustrious Member

    Messages:
    4,623
    Likes Received:
    725
    Best Answers:
    152
    Trophy Points:
    470
    #2
    Should work - have you restarted the server?

    Besides, 16384 Kib is 16Mib, so it should work regardless...
     
    PoPSiCLe, Apr 9, 2015 IP
  3. pmf123

    pmf123 Notable Member

    Messages:
    1,449
    Likes Received:
    81
    Best Answers:
    0
    Trophy Points:
    215
    #3
    just do it from the shell

    mysql --user=xxx --password=xxx database < file.sql
     
    pmf123, Apr 18, 2015 IP