Search code examples
phpmysqlphpmyadminxamppubuntu-16.04

phpMyAdmin - Error Incorrect format parameter

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

Solution

  • 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