Upgrade & Secure Your Future with DevOps, SRE, DevSecOps, MLOps!

We spend hours on Instagram and YouTube and waste money on coffee and fast food, but won’t spend 30 minutes a day learning skills to boost our careers.
Master in DevOps, SRE, DevSecOps & MLOps!

Learn from Guru Rajesh Kumar and double your salary in just one year.


Get Started Now!

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

First of all, we have to see some basic settings which are situated in php.ini. 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.

you can see below the error message image:

phpMyAdmin Error

so let’s see the step to solve it easily.

Step 1 – Open Xampp control panel and click on apache config button and click on PHP (php.ini)

Xampp Control Panel
Xampp control panel (php.ini)

Step 2 – Then search below settings for easily import any database:
upload_max_filesize=64M
post_max_size=64M
max_execution_time=100
memory_limit=128M

you can change the above settings as per your database size. then save the file.

Step 3 – Now you have to restart the Apache and MySQL.

Step 4 – 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.

Reference

 

Certification Courses

DevOpsSchool has introduced a series of professional certification courses designed to enhance your skills and expertise in cutting-edge technologies and methodologies. Whether you are aiming to excel in development, security, or operations, these certifications provide a comprehensive learning experience. Explore the following programs:

DevOps Certification, SRE Certification, and DevSecOps Certification by DevOpsSchool

Explore our DevOps Certification, SRE Certification, and DevSecOps Certification programs at DevOpsSchool. Gain the expertise needed to excel in your career with hands-on training and globally recognized certifications.