mysql import Incorrect format parameter code example

Example 1: phpMyAdmin > Error Incorrect format parameter

upload_max_filesize=64M
post_max_size=64M

Example 2: phpMyAdmin - Error Incorrect format parameter

1. Exceed PHP limits
First of all, we start by checking the PHP parameters.

However, the exact location of the PHP configuration depends on the server we 
are looking into. Let’s discuss a few such types.

1. If it’s WHM, then the config is located at
WHM->Server configuration -> Tweak Settings.

2. For the Ubuntu server with Apache, it is in 
/etc/php/{PHPversion}/apache2/php.ini.

3. If it’s a local machine with Xammp: xampp/php/php.ini.

4. For Nginx webserver : /etc/php/{PHPversion}.

We change the following parameters based on requirements.

max_execution_time = 3000
max_input_time = 60
memory_limit = 128M
post_max_size = 200M
upload_max_filesize = 200M

We restart the apache service for the changes to reflect. If the issue still 
persists, we further change the execution time limit in the phpmyadmin 
configuration file. For WHM/cPanel it is generally located at 
/usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php. Here again, 
configuration file location may vary depending on the type of server.

reference:
https://bobcares.com/blog/phpmyadmin-error-incorrect-format-parameter/

Example 3: phpMyAdmin - Error Incorrect format parameter

Causes of phpMyAdmin error incorrect format parameter

We’ll move on and find the possible reasons for the error.

From our expertise in managing servers, incorrect format parameter appears due 
to multiple reasons such as:

1. Running a script more than the defined maximum execution time.
2. Similarly, if the requested data exceeds the defined limit.
3. The script may need more memory than the defined memory limit.
4. The size of post data goes higher than the defined maximum post data size.
5. Likewise, if the size of the backup file is more than defined maximum file 
size.
6. Due to corrupted SQL.