How to fix phpmyadmin error, incorrect format parameter that appeared while importing a database?

Asked by Anonymous on 09 Aug 2018 86810 Views

Anonymous on 09 Aug 2018

phpMyAdmin Error - incorrect format parameter might appear due to multiple reasons such as:

  • Execution of a script exceeding the defined maximum execution time.
  • Parsing of requested input data exceeds the defined maximum input parsing time.
  • Script needing operating memory higher than the one defined in memory limit.
  • Size of post data higher than the defined maximum post data size.
  • Size of the file being uploaded higher than the defined maximum file size.

All of the above stated settings are defined in php.ini file whose path is xampp/php/php.ini. You can open the xampp application and click on the config option beside the apache controls and click on the php.ini from the dropdown list that appears.

Search for the above stated settings with the help of the phrases stated below and set their values higher as needed. Here's my personal settings.

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

Apart from those changes, it's better to ensure the collation of the newly created database is exactly the same as the one which is being imported to avoid further issues within the application because of the characters.

Restart your apache server and check if it works for you. In most of the cases, this problem occurs because of the size of the database file being imported and the time it takes to get executed. You can compress the database file to a .zip file and try to import it.

If the error still exists, open the xampp/phpmyadmin/libraries/config.default.php and disable the script execution time limit. Search for the phrase ExecTimeLimit as show below.

$cfg['ExecTimeLimit'] = 300;

All you have to do is change the ExecTimeLimit value to 0 to get it disabled.

$cfg['ExecTimeLimit'] = 0;

Add a comment if your problem still persists and we'll try to explore it and get solutions.

I tried to apply the steps provided to import database to a Linux server but the Phpmyadmin Error still surface

Dunka Dinget on 25 Oct 2019

Did you contact your hosting provider describing the issue? sudo service apache2 restart and sudo service mysql restart might help.

Jiwan on 22 Mar 2020

You must be logged in to answer a question. or