I downloaded the sql file of the project I have and wanted to upload it to phpMyAdmin on localhost. But every time I want to load I getIncorrect format parameter
error. The size of my file is also 32 MB. When I searched for the solution to the problem, I found phpMyAdmin - Error > Incorrect format parameter? answers on Stack Overflow. However, when I applied the answers here, nothing changed. For some reason I can't change it (Max: 8,192KiB). I am using 8.0.8 as the php version in MAMP and I made these changes in the 8.0.8 php.ini file among the files. So I think I didn't do anything wrong, but for some reason I couldn't solve the problem. I'm putting my php.ini file below, you can check it from there.
Here is my 8.0.8 php.ini
; Maximum allowed size for uploaded files.
; http://php.net/upload-max-filesize
upload_max_filesize = 64M
; Maximum size of POST data that PHP will accept.
; Its value may be 0 to disable the limit. It is ignored if POST data reading
; is disabled through enable_post_data_reading.
; http://php.net/post-max-size
post_max_size = 64M
I solved the problem with a friend on another forum. He told me to approach it from a different perspective. He said, instead of increasing the maximum upload size, reduce the file you will upload. In short, if you are getting the same error, first compress the sql file you want to upload into a .zip file and try to install it that way. Most likely your problem will be solved. I wish you less error days:)
Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.
Find the answer in similar questions on our website.
Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.
PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites.
The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/
Welcome to the Q&A site for web developers. Here you can ask a question about the problem you are facing and get answers from other experts. We have created a user-friendly interface so that you can quickly and free of charge ask a question about a web programming problem. We also invite other experts to join our community and help other members who ask questions. In addition, you can use our search for questions with a solution.
Ask about the real problem you are facing. Describe in detail what you are doing and what you want to achieve.
Our goal is to create a strong community in which everyone will support each other. If you find a question and know the answer to it, help others with your knowledge.