PHPMyAdmin – Error Incorrect Format Parameter xampp Ubuntu Cpanel


Through this tutorial, you will learn how to fix/solve phpmyadmin – error incorrect format parameter xampp ubuntu cpanel.

Commonly this type of error come, when you import database. So,

How to fix phpMyAdmin error ‘Incorrect Format Parameter’

There are 4 ways to fix or solve phpmyadmin import database error incorrect format parameter xampp ubuntu cpanel:

  • Solution 1: Import Compress SQL file
  • Solution 2: Increase the PHP limits
  • Solution 3: Directly run using SQL tab
  • Solution 4: Using SSH Command

Solution 1: Import Compress SQL file

Compress sql file and then import to database. PHPMyAdmin supports compressed file import directly.

Solution 2: Increase the PHP limits

Open your php.ini file and edit the php.ini file, in our case, the path is “/etc/php.ini”. You need to change the given values accordingly based on your requirements:

max_execution_time = 3000
max_input_time = 600
memory_limit = 128M
post_max_size = 100M
upload_max_filesize = 100M

Solution 3: Directly run using SQL tab

In the third solution, You can open your sql file in text editor and copy from your sql file into SQL tab. Then run this into your PHPMyAdmin console. However, this option is less likely to succeed if the data is large and exceed default maximum execution time in PHP.

Solution 4: import of Database using SSH Command

If the above solution is none. Then you can import the backup of the database using the SSH option:

mysql -u user -p database < backup_file.sql

Conclusion

Through this tutorial, you have learned how to fix/solve phpmyadmin – error incorrect format parameter xampp ubuntu cpanel.

Recommended Tutorials

Jassweb always keeps its services up-to-date with the latest trends in the market, providing its customers all over the world with high-end and easily extensible internet, intranet and extranet products.

Resources

Blog

Developer Center

Exchange

FAQ

Contact

[email protected]

+919878044183