Asked by Anonymous on 09 Aug 2018 75783 Views
Anonymous on 09 Aug 2018
phpMyAdmin Error - incorrect format parameter might appear due to multiple reasons such as:
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.
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
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