{"id":6825,"date":"2019-10-04T14:01:08","date_gmt":"2019-10-04T14:01:08","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=6825"},"modified":"2021-11-16T09:45:35","modified_gmt":"2021-11-16T09:45:35","slug":"how-to-fix-phpmyadmin-error-incorrect-format-parameter-that-appeared-while-importing-a-database","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/how-to-fix-phpmyadmin-error-incorrect-format-parameter-that-appeared-while-importing-a-database\/","title":{"rendered":"How to fix PHPMyAdmin error, incorrect format parameter that appeared while importing a database?"},"content":{"rendered":"\n

First of all, we have to see some basic settings which are situated in php.ini<\/em><\/strong>. whenever we upload a database which size will be greater than max upload size and others some more settings also, then you will see incorrect format parameter under PHPMyAdmin.<\/p>\n\n\n\n

you can see below the error message image:<\/p>\n\n\n\n

\"\"
phpMyAdmin Error<\/strong><\/figcaption><\/figure>\n\n\n\n

so let’s see the step to solve it easily. <\/p>\n\n\n\n

Step 1<\/strong> – Open Xampp control panel and click on apache config button and click on PHP (php.ini)<\/p>\n\n\n\n

\"\"
Xampp Control Panel<\/strong><\/em><\/figcaption><\/figure>\n\n\n\n
\"\"
Xampp control panel (php.ini)<\/figcaption><\/figure>\n\n\n\n

Step 2<\/strong> – Then search below settings for easily import any database:
upload_max_filesize=64M
post_max_size=64M
max_execution_time=100
memory_limit=128M<\/em>
you can change the above settings as per your database size. then save the file.<\/p>\n\n\n\n

Step 3<\/strong> – Now you have to restart the Apache<\/strong> and MySQL<\/strong>.<\/p>\n\n\n\n

Step 4<\/strong> – Now you have to import your database SQL file under your database like (demo) and you see that your database will import correctly and error will be gone. so if you have more questions on this topic then comment us we will give you more solutions on it.<\/p>\n\n\n\n

Reference<\/strong><\/p>\n\n\n\n