500 error during database dump

[Teo]

Hello everyone,

i'm having a weird issue maybe you already know why, when i dump a database restoring it from phpmyadmin is a 50 MB size database, after the upload it load and at a certain point it stops showing a 500 timeout error. When i see the error the 1st time i tough it was something in the php.ini file so i edited it setting loading/timeout parameters all to -1 to avoid that issue but nothing changed.
i set:
max_execution_time = -1
max_input_time = -1
max_input_nesting_level = 64
max_input_vars = 10000
memory_limit = 256M
post_max_size = 256M
upload_max_filesize = 512M
default_socket_timeout = -1
pdo_mysql.cache_size = 20000
mysql.connect_timeout = -1
mysqli.max_links = -1
mysqli.default_port = 3306

Now, is maybe something with the httpd or anything else blocking that script?

thank you in advance.

[skurudo]

Which os do you use?
What's in log /var/log/apache2/other_vhosts_access.log? (httpd for centos)
Show output <?php phpinfo(); ?>

PS: I think about upload size limit

[Teo]

Hello, thank you for your reply.

i'm using CentOS 6.6 (x86_64)

this is my php info: http://cloudxme.com/phpinfo.php

i had to reduce some settings because i went into a bad bots flooding issue...

----edit---

i just tryed and this is the error:

cloudxme.com

500
Internal Server Error

Sorry, something went wrong :(

[Thu May 14 09:11:19 2015] [notice] caught SIGTERM, shutting down
[Thu May 14 09:11:20 2015] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Thu May 14 09:11:20 2015] [notice] Digest: generating secret for digest authentication ...
[Thu May 14 09:11:20 2015] [notice] Digest: done
[Thu May 14 09:11:20 2015] [notice] mod_ruid2/0.9.8 enabled
[Thu May 14 09:11:20 2015] [notice] Apache/2.2.15 (Unix) DAV/2 mod_fcgid/2.3.9 PHP/5.4.40 mod_ssl/2.2.15 OpenSSL/1.0.0-fips configured -- resuming normal operations
[Thu May 14 09:11:25 2015] [notice] caught SIGTERM, shutting down
[Thu May 14 09:11:26 2015] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Thu May 14 09:11:26 2015] [notice] Digest: generating secret for digest authentication ...
[Thu May 14 09:11:26 2015] [notice] Digest: done
[Thu May 14 09:11:26 2015] [notice] mod_ruid2/0.9.8 enabled
[Thu May 14 09:11:26 2015] [notice] Apache/2.2.15 (Unix) DAV/2 mod_fcgid/2.3.9 PHP/5.4.40 mod_ssl/2.2.15 OpenSSL/1.0.0-fips configured -- resuming normal operations
[Thu May 14 10:50:58 2015] [error] [client 202.180.164.15] File does not exist: /var/www/html/Ringing.at.your.dorbell!, referer: http://google.com/search?q=2+guys+1+horse
[Thu May 14 10:50:58 2015] [error] [client 202.180.164.15] File does not exist: /var/www/html/error, referer: http://google.com/search?q=2+guys+1+horse
[Thu May 14 10:51:00 2015] [error] [client 202.180.164.15] File does not exist: /var/www/html/Diagnostics.asp
[Thu May 14 10:51:00 2015] [error] [client 202.180.164.15] File does not exist: /var/www/html/error
[Thu May 14 13:44:23 2015] [notice] SIGHUP received. Attempting to restart
[Thu May 14 13:44:23 2015] [warn] NameVirtualHost 198.71.81.230:8080 has no VirtualHosts
[Thu May 14 13:44:23 2015] [warn] NameVirtualHost 198.71.81.230:8443 has no VirtualHosts
[Thu May 14 13:44:23 2015] [warn] NameVirtualHost 198.71.81.22:8443 has no VirtualHosts
[Thu May 14 13:44:23 2015] [notice] Digest: generating secret for digest authentication ...
[Thu May 14 13:44:23 2015] [notice] Digest: done
[Thu May 14 13:44:23 2015] [notice] mod_ruid2/0.9.8 enabled
[Thu May 14 13:44:23 2015] [notice] Apache/2.2.15 (Unix) DAV/2 mod_fcgid/2.3.9 PHP/5.4.40 mod_ssl/2.2.15 OpenSSL/1.0.0-fips configured -- resuming normal operations

[skurudo]

But this issue with 500 error continue?

Check your permission on /var/lib/php/session (chmod 1777 /var/lib/php/session)

[Teo]

Hello i just edited the prw post

[Teo]

But this issue with 500 error continue?

Check your permission on /var/lib/php/session (chmod 1777 /var/lib/php/session)

yes and permission are set 777 already there.

[Teo]

update:

i tried also the 1777 and after that always same error at /phpmyadmin/import.php

thank you for your assistance.

[azreal]

try using CLI to import big database

Code: Select all

backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

restore:# mysql -u root -p[root_password] [database_name] < dumpfilename.sql

[Botrax]

I also had this issue importing a 30meg zip of MySql Database.

Error 500 when importing with PhpMyAdmin, even when adjusting script timeouts and upload sizes in PHP, and chunk size in MySQL.conf. System takes a few minutes before becoming responsive again.

Vesta 0.9.8 on CentOS 6.6 x64