Page 1 of 1
500 mysql error
Posted: Mon May 25, 2015 6:10 pm
by vestacp89
I try upload via phpmyadmin 50mb .sql file and after load i get
500 error,
I edit php.ini , edit and incrase limit on 128mb
Code: Select all
post_max_size = 128M
upload_max_filesize = 128M
I use
centos 6, anyone ?
Re: 500 mysql error
Posted: Mon May 25, 2015 9:19 pm
by skurudo
vestacp89 wrote:I use centos 6, anyone ?
What's about nginx client_max_body_size?
What's in apache/mysql error log?
Re: 500 mysql error
Posted: Tue Jun 02, 2015 10:46 pm
by eduzro
It happens the same to me when importing a Drupal database of 8MB with phpMyAdmin. First the file is uploaded correctly and then, it keeps loading (I suppose that is executing queries) and finally it redirects me to the 500 error page. Even if I split the database and import a few tables, it fails when importing 5MB of tables. Taking a look at the cpu usage, it des not grow too much; if it´s at 0.5% it goes to 2% while doing the import.
I have been trying to fix this for hours... any idea?
Thanks!
I also use CentOS 6
In php.ini I have:
post_max_size = 20M
upload_max_filesize = 20M
in my.conf
max_allowed_packet=500M
wait_timeout=600
interactive_timeout=500
long_query_time=50
Just in case, in httpd.conf I have
Timeout 600
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 10
Re: 500 mysql error
Posted: Thu Jun 04, 2015 1:59 pm
by Teo
Re: 500 mysql error
Posted: Fri Jun 05, 2015 5:15 pm
by eduzro
It seems many of us are having that problem. When importing, if I check CPU, it´s very low (3%-4%)... can it be related to the issue? I tried many things and don´t know where to look at. Many people imports very big databases with no problems, so a 8MB database like mine should be ridiculous. I use a dedicated kimsufi server (the one with 16GB Ram)... so... no idea.