Control Web Panel

WebPanel => MySQL => Topic started by: ali118 on January 22, 2017, 07:54:04 AM

Title: 413 Request Entity Too Large by phpmyadmin
Post by: ali118 on January 22, 2017, 07:54:04 AM
413 Request Entity Too Large
When I upload a database.sql I get this error.

nginx
this problem by phpmyadmin
Title: Re: 413 Request Entity Too Large by phpmyadmin
Post by: Gogo on January 22, 2017, 03:04:54 PM
Try to use mysql dumpers to import/export large databases and any kind of large entities. eg. mysqldumper.net
Or if you are familiar with shell you can simply use
Code: [Select]
mysql -uUSER -pPASSWORD database_name < file_name.sql
I had same problem but I didn't even try to find solution to fix that because I used shell cmd to import fajl, it's easier than searching for a solution.
Title: Re: 413 Request Entity Too Large by phpmyadmin
Post by: Sandeep on January 23, 2017, 08:44:18 AM
Code: [Select]
client_max_body_size 500M;

Add this line in /usr/local/cwpsrv/conf/cwpsrv.conf under http {

then restart the cwp
Code: [Select]
systemctl restart cwpsrv.service
(http://i.imgur.com/Y0uvcl4.png)

you can increase or decrease client_max_body_size - 500M to the desired value according to your needs

also applied to rouncube and phpmyadmin
Title: Re: 413 Request Entity Too Large by phpmyadmin
Post by: Sandeep on January 23, 2017, 08:55:58 AM
to increase php upload limit modify php.ini memory limit :
/usr/local/cwp/php71/php.ini

then restart the cwp and  cwp php
Code: [Select]
systemctl restart cwpsrv.service
Code: [Select]
systemctl restart cwp-phpfpm.service
also applied to rouncube and phpmyadmin
Title: Re: 413 Request Entity Too Large by phpmyadmin
Post by: OfficePlus NC on January 24, 2017, 05:45:18 AM
Thank you,

I encountered the same problem with a 1.8MB SQL file and CentOS 7

The solution solved my problem

Code: [Select]
client_max_body_size 500M;
Title: Re: 413 Request Entity Too Large by phpmyadmin
Post by: pauliakas on January 31, 2017, 03:35:31 PM
Not helping for me.
I change this line but still cant import SQL 1MB
Title: Re: 413 Request Entity Too Large by phpmyadmin
Post by: Administrator on January 31, 2017, 10:53:12 PM
if this is centos 7 then try

Code: [Select]
yum -y remove cwpsrv
yum -y install cwpsrv
/scripts/restart_cwpsrv
Title: Re: 413 Request Entity Too Large by phpmyadmin
Post by: problemao on March 06, 2017, 01:20:29 PM
Not helping for me.
I change this line but still cant import SQL 1MB

Same here... any1 find a solution to fix the import database at phpmyadmin?
Title: Re: 413 Request Entity Too Large by phpmyadmin
Post by: leon3xs on March 23, 2017, 12:34:37 PM
Same here too!
Title: Re: 413 Request Entity Too Large by phpmyadmin
Post by: joeey on April 06, 2023, 12:35:01 PM
After trying the above suggestions I kept getting the 413 error on my file upload. I related this to a timeout issue, maybe server slow to read files so I changed the following line

keepalive_timeout  65;

to

keepalive_timeout  650;

File location /usr/local/cwpsrv/conf/cwpsrv.conf under http {

That seemed to do the trick. Now my files upload ok.

Remember to restart services especially apache.
Title: Re: 413 Request Entity Too Large by phpmyadmin
Post by: overseer on April 06, 2023, 02:48:09 PM
I haven't actually encountered this myself, probably because I use the CLI for larger DB loading & backup tasks. But thanks for resurfacing this thread! I'll enact it on my servers for the sake of clients who live & die by phpMyAdmin.