Author Topic: 413 Request Entity Too Large by phpmyadmin  (Read 28987 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
413 Request Entity Too Large by phpmyadmin
« 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

Offline
**
Re: 413 Request Entity Too Large by phpmyadmin
« Reply #1 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.

Offline
*****
Re: 413 Request Entity Too Large by phpmyadmin
« Reply #2 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


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

also applied to rouncube and phpmyadmin
« Last Edit: January 23, 2017, 09:00:01 AM by Sandeep »

Offline
*****
Re: 413 Request Entity Too Large by phpmyadmin
« Reply #3 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
« Last Edit: January 23, 2017, 08:58:13 AM by Sandeep »

Offline
*
Re: 413 Request Entity Too Large by phpmyadmin
« Reply #4 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;
« Last Edit: January 24, 2017, 05:52:11 AM by OfficePlus NC »

Offline
*
Re: 413 Request Entity Too Large by phpmyadmin
« Reply #5 on: January 31, 2017, 03:35:31 PM »
Not helping for me.
I change this line but still cant import SQL 1MB

Offline
*
Re: 413 Request Entity Too Large by phpmyadmin
« Reply #6 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
AntiDDoS Protection (web + mail)
http://centos-webpanel.com/website-ddos-protection-proxy

Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp


Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Do you need Fast and FREE Support included for your CWP linux server?
http://centos-webpanel.com/noc-partner-list
Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: 413 Request Entity Too Large by phpmyadmin
« Reply #7 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?

Offline
*
Re: 413 Request Entity Too Large by phpmyadmin
« Reply #8 on: March 23, 2017, 12:34:37 PM »
Same here too!

Offline
*
Re: 413 Request Entity Too Large by phpmyadmin
« Reply #9 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.

Offline
****
Re: 413 Request Entity Too Large by phpmyadmin
« Reply #10 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.