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
