Contact Us

Address: Ground Floor, Bablu Mension, Karigorpara Road, Amjhupi, Meherpur, 7101
Phone: +8801713902426

    How to Increase File Import Size and PHP Limit in XAMPP/WAMP June 30, 2016|

    How to Increase File Import Size and PHP Limit in XAMPP/WAMP

    Last month I was trying to upload a big new paper site to rebuild, SQL file size was 4MB, I was not aware XAMPP’s default SQL upload size is 2MB, problem! Got a good solution for it to increase file import size. I am sure this is a very common facing many developers, I am going to relief them, it’s very simple but effective. While I was trying to upload 4MB size SQL, which was showing this error message:

    “No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16.”


    File upload size was 2MB

    Increase File Import Size and PHP Limit in XAMPP/WAMP using php.ini

    We have to search php.ini file first, I am using XAMPP so showing you mainly it, please try on WAMP, these are more or less same. Many people telling this php.ini will be found on C:\xampp\apache\bin\php.ini but I am getting it on C:\xampp\php\php.ini find these folders or search on file explorer.
    Open that php.ini file and search for upload_max_filesize

    ; File Uploads ;
    ; Whether to allow HTTP file uploads.
    ; Temporary directory for HTTP uploaded files (will use system default if not
    ; specified).
    ; Maximum allowed size for uploaded files.
    ; Maximum number of files that can be uploaded via a single request

    Default is 2M, increase as needed, I made it 56M

    Then search for post_max_size this should be greater than upload_max_filesize. You know this is maximum, so this should be same or greater than normal.

    ; Maximum size of POST data that PHP will accept.
    ; Its value may be 0 to disable the limit. It is ignored if POST data reading
    ; is disabled through enable_post_data_reading.

    Default is 8M, increase it greater than upload_max_filesize, Otherwise phpMyAdmin will not allow you to upload more than 8MB, I made it 128M.

    Increase PHP Limit in XAMPP/WAMP using php.ini

    Using same method above search php.ini file, open it and search for memory_limit

    ; Maximum amount of memory a script may consume (128MB)

    Its default value is 128M, increase it as needed, I made it 1024M.

    Alternatively you can use MySql client program always. To upload large file you can use

    mysql -h hostname -u username -p databasename < wordpress.bak.sql

    That can ask your password, enter your password and press enter.

    Don’t forget restart you XAMPP/WAMP after doing these, if you could not find restart button, no problem restart your computer and check the effects. Enjoy! If you face any problem, don’t be shy, feel free to ask me.

    Chat on WhatsApp