500 mysql error

[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 ?

[skurudo]

I use centos 6, anyone ?

What's about nginx client_max_body_size?
What's in apache/mysql error log?

[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

[Teo]

same to me as i posted here: http://forum.vestacp.com/viewtopic.php?f=11&t=8353

[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.