phpMyAdmin - Error Incorrect format parameter

Question

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.

please restart server once you made changes – Tijo John Feb 11 '19 at 06:38 — Tijo John, Feb 11 '19 at 06:38

score 7 · Accepted Answer · answered Feb 11 '19 at 06:39

7

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

answered Feb 11 '19 at 06:39

Sayed Mohd Ali

I changed the things you said above and tried already.But nothing changed. And I tried that command too but it needs mysql server which is already installed to start running and not the installed xampp. – newbie Feb 11 '19 at 06:45
There is no such database. – newbie Feb 11 '19 at 07:36
the name of the database you are typing while using command is wrong, so please write correct databasename or create the database with the same name you are using in command – Sayed Mohd Ali Feb 11 '19 at 07:51
OK..but i want that db to be created in my xampp phpmyadmin ..Is it correct to do that. – newbie Feb 11 '19 at 07:57
phpmyadmin is just a tool to create database in mysql. it is the same thing. – Sayed Mohd Ali Feb 11 '19 at 09:14

score 2 · Answer 2 · edited Mar 11 '19 at 11:25

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.

edited Mar 11 '19 at 11:25

frido

answered Mar 11 '19 at 10:00

Shahriar Sadat

score 2 · Answer 3 · answered Mar 12 '19 at 09:18

2

thanks for thi answer post_max_size=500M

upload_max_filesize=500M

memory_limit=900M

answered Mar 12 '19 at 09:18

Virat Virat

score 1 · Answer 4 · answered Nov 26 '20 at 07:58

1

There file format can be .sql.zip Shown in the attached picture. It happened to me.

answered Nov 26 '20 at 07:58

Nazmul Haque

4 Answers4