skip to Main Content

I tried to import a large sql file but its not getting imported.
And it shows the following error.

phpMyAdmin – Error
Incorrect format parameter

I have been using Xampp-php 5.6 in ubuntu16.04.

I have tried these links given below already but none of it worked.

https://www.webtrickshome.com/forum/how-to-fix-phpmyadmin-error-incorrect-format-parameter-that-appeared-while-importing-a-database

importing db phpMyAdmin – Error Incorrect format parameter

Importing large database file in MAMP phpMyAdmin

4

Answers


  1. You can easily import using cmd promt

    mysql -u username(of phpmyadmin) -p database_name < file_path/file_name.sql
    

    you can also do the changes in php.ini file to increase upload size of phpmyadmin.

    in php.ini of your PHP installation (note: depending if you want it for CLI, Apache, or Nginx, find the right php.ini to manipulate)

    post_max_size=500M
    
    upload_max_filesize=500M
    
    memory_limit=900M
    

    or set other values.

    Restart/reload apache if you have apache installed or php-fpm for nginx if you use nginx.

    Remote server?

    increase max_execution_time as well, as it will take time to upload the file.

    NGINX installation?

    you will have to add: client_max_body_size 912M; in /etc/nginx/nginx.conf to the http{…} block

    Login or Signup to reply.
  2. I was facing the same problem when I was trying to import a 90mb database. You can solve this problem by opening

    xampp->phpMyadmin->libraries->config.default.php
    

    after opening the file search for $cfg['ExecTimeLimit'] = 300;

    Here you can set the time to 1000 or whatever you want after the equal sign. The default value is 300.

    Login or Signup to reply.
  3. thanks for thi answer
    post_max_size=500M

    upload_max_filesize=500M

    memory_limit=900M

    Login or Signup to reply.
  4. There file format can be .sql.zip
    Shown in the attached picture. It happened to me.

    enter image description here

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search