Olá, estou tendo dificuldades para importar tabelas do excel acima de 2M. Configuração do servidor: Apache2 + mysql. Abaixo de 2M estou conseguindo. O que deve está acontecendo?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Heya, @lourivaldasilvajunior
Check your MySQL configuration for any size limits that might affect imports. For example, the
max_allowed_packet
setting in MySQL can affect the maximum size of data packets that can be sent to the server. You may need to increase this value if it’s too low for your import.I assume you’re using PHP as well, so you can increse the following limits in the PHP configuration as well:
upload_max_filesize
andpost_max_size
directives in yourphp.ini
file to allow larger uploads. For example:After making changes, remember to restart your Apache server for the changes to take effect.
Hope that this helps!
Heya,
The problem you’re describing is a common one when dealing with web servers and PHP configurations. When you’re trying to upload large files, such as Excel tables over 2MB, there are a few configurations that can restrict this:
PHP
upload_max_filesize
Directive: This is the maximum size of an uploaded file. If the Excel file is larger than this setting, you’ll be unable to upload it.PHP
post_max_size
Directive: This sets the maximum size for POST data. The uploaded file is sent to the server using the POST method, so this setting also affects file uploads. Make sure this value is larger thanupload_max_filesize
.PHP
memory_limit
Directive: This is the maximum amount of memory that a PHP script can consume. If the process of handling the uploaded file exceeds this memory limit, it will fail.Apache Timeout & Other Configurations: If the upload process takes too long, Apache might time out.
Client-Side Limitations: Sometimes, the client or browser might have restrictions or issues with larger uploads.
How to Resolve:
Edit your
php.ini
file. You can find its location by creating aphpinfo()
file or using the commandphp --ini
.Modify or add the following lines:
You can adjust the values based on your needs. For instance, if you need to upload files up to 10MB, set
upload_max_filesize
to10M
and adjust the other values accordingly.Save the
php.ini
file.Restart your Apache server to apply the changes:
If you’ve made these changes and still face issues, consider checking Apache configurations, any .htaccess file for restrictions, and also ensure there’s enough space on your server to handle the uploads. Additionally, look into server logs for any error messages that can provide more insights into the issue.