Page 1 of 1

mysql phpmyadmin 500 error

Posted: Thu Dec 18, 2014 5:29 am
by reinhard
Hello

My Question is
When Import some data.sql file (size : 30mb over)
phpmyadmin always returns 500 error (Internal Server Error)

In this Forum says edit php.ini file
already edited php.ini file.

Code: Select all

------------------------------/etc/php.ini File----------------------------------
; Maximum allowed size for uploaded files.
; http://php.net/upload-max-filesize
upload_max_filesize = 64M

; Maximum size of POST data that PHP will accept.
; Its value may be 0 to disable the limit. It is ignored if POST data reading
; is disabled through enable_post_data_reading.
; http://php.net/post-max-size
post_max_size = 64M
And I typed like this in ssh console.

Code: Select all

[root@ns tmp]# service httpd restart
But nothing is changed.
it is not work.
How Can I fix it?

Re: mysql phpmyadmin 500 error

Posted: Sun Dec 28, 2014 6:01 pm
by drMacFaulty
I could be wrong, but maybe it could be something with the max_packet size of MySQL itself? What max. upload size does PHPMyAdmin reports (it is always right next to the browse button).

You could take a look here and see if it helps: viewtopic.php?f=14&t=6677&p=19776#p19776