1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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,447
    Likes Received:
    75
    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