Backup problem via phpmyadmin

aaP_clous

Helo,
When I want to backup my database (it's about 1.4 GB in size) I choose gzip.
When I export the database, only 54.4 MB is downloaded and it doesn't go any further... it stays there. I try for the fifth time and the same thing always happens, it stops exactly at 54.4 MB.

These are the softwares I have installed (picture below):

aaPanel_Kern

Hello, have you modified the php timeout configuration used by phpmyadmin?
Is it okay to backup directly from the panel or use commands to backup?

aaP_clous

I didn't touch anything.
I noticed that I only have this problem with gzip, when I download pure SQL then the database downloads without any problems.

EDIT:
When I want the .zip database to be downloaded, after 2 minutes I get an error;
Service Unavailable
The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.

I have a server with 2 CPUs and 5 GB RAM.

aaPanel_Kern

Hello,
It is recommended that you view the specific error information
/www/wwwlogs/error_log

aaP_clous

This is my error:log fil, the spoiler is below..

[Mon Apr 21 00:06:20.915311 2025] [ssl:warn] [pid 34203:tid 34203] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Mon Apr 21 00:06:20.915496 2025] [lbmethod_heartbeat:notice] [pid 34203:tid 34203] AH02282: No slotmem from mod_heartmonitor
[Mon Apr 21 00:06:20.950951 2025] [mpm_event:notice] [pid 34203:tid 34203] AH00489: Apache/2.4.62 (Unix) OpenSSL/1.1.1o configured -- resuming normal operations
[Mon Apr 21 00:06:20.950985 2025] [core:notice] [pid 34203:tid 34203] AH00094: Command line: '/www/server/apache/bin/httpd'
[Mon Apr 21 00:10:50.800268 2025] [mpm_event:notice] [pid 34203:tid 34203] AH00493: SIGUSR1 received. Doing graceful restart
[Mon Apr 21 00:10:50.815206 2025] [ssl:warn] [pid 34203:tid 34203] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Mon Apr 21 00:10:50.815285 2025] [lbmethod_heartbeat:notice] [pid 34203:tid 34203] AH02282: No slotmem from mod_heartmonitor
[Mon Apr 21 00:10:50.815497 2025] [mpm_event:notice] [pid 34203:tid 34203] AH00489: Apache/2.4.62 (Unix) OpenSSL/1.1.1o configured -- resuming normal operations
[Mon Apr 21 00:10:50.815502 2025] [core:notice] [pid 34203:tid 34203] AH00094: Command line: '/www/server/apache/bin/httpd'
[Mon Apr 21 00:15:56.186275 2025] [mpm_event:notice] [pid 34203:tid 34203] AH00493: SIGUSR1 received. Doing graceful restart
[Mon Apr 21 00:15:56.194469 2025] [ssl:warn] [pid 34203:tid 34203] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Mon Apr 21 00:15:56.194539 2025] [lbmethod_heartbeat:notice] [pid 34203:tid 34203] AH02282: No slotmem from mod_heartmonitor
[Mon Apr 21 00:15:56.195221 2025] [mpm_event:notice] [pid 34203:tid 34203] AH00489: Apache/2.4.62 (Unix) OpenSSL/1.1.1o configured -- resuming normal operations
[Mon Apr 21 00:15:56.195230 2025] [core:notice] [pid 34203:tid 34203] AH00094: Command line: '/www/server/apache/bin/httpd'
[Mon Apr 21 00:16:05.737312 2025] [mpm_event:notice] [pid 34203:tid 34203] AH00491: caught SIGTERM, shutting down
[Mon Apr 21 00:16:20.880978 2025] [ssl:warn] [pid 863:tid 863] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Mon Apr 21 00:16:20.883905 2025] [lbmethod_heartbeat:notice] [pid 863:tid 863] AH02282: No slotmem from mod_heartmonitor
[Mon Apr 21 00:16:21.041911 2025] [mpm_event:notice] [pid 863:tid 863] AH00489: Apache/2.4.62 (Unix) OpenSSL/1.1.1o configured -- resuming normal operations
[Mon Apr 21 00:16:21.041967 2025] [core:notice] [pid 863:tid 863] AH00094: Command line: '/www/server/apache/bin/httpd'
[Mon Apr 21 00:33:01.379679 2025] [mpm_event:notice] [pid 863:tid 863] AH00493: SIGUSR1 received. Doing graceful restart
[Mon Apr 21 00:33:01.396770 2025] [ssl:warn] [pid 863:tid 863] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Mon Apr 21 00:33:01.398826 2025] [ssl:warn] [pid 863:tid 863] AH01909: 0b842aa5.phpmyadmin:443:0 server certificate does NOT include an ID which matches the server name
[Mon Apr 21 00:33:01.398984 2025] [lbmethod_heartbeat:notice] [pid 863:tid 863] AH02282: No slotmem from mod_heartmonitor
[Mon Apr 21 00:33:01.399138 2025] [mpm_event:notice] [pid 863:tid 863] AH00489: Apache/2.4.62 (Unix) OpenSSL/1.1.1o configured -- resuming normal operations
[Mon Apr 21 00:33:01.399142 2025] [core:notice] [pid 863:tid 863] AH00094: Command line: '/www/server/apache/bin/httpd'
[Mon Apr 21 00:33:07.207042 2025] [mpm_event:notice] [pid 863:tid 863] AH00493: SIGUSR1 received. Doing graceful restart
[Mon Apr 21 00:33:07.220690 2025] [ssl:warn] [pid 863:tid 863] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Mon Apr 21 00:33:07.221156 2025] [ssl:warn] [pid 863:tid 863] AH01909: 0b842aa5.phpmyadmin:443:0 server certificate does NOT include an ID which matches the server name
[Mon Apr 21 00:33:07.221671 2025] [lbmethod_heartbeat:notice] [pid 863:tid 863] AH02282: No slotmem from mod_heartmonitor
[Mon Apr 21 00:33:07.221893 2025] [mpm_event:notice] [pid 863:tid 863] AH00489: Apache/2.4.62 (Unix) OpenSSL/1.1.1o configured -- resuming normal operations
[Mon Apr 21 00:33:07.221899 2025] [core:notice] [pid 863:tid 863] AH00094: Command line: '/www/server/apache/bin/httpd'
[Mon Apr 21 00:35:41.697000 2025] [proxy_fcgi:error] [pid 2831:tid 2882] [remote 189.28.77.151:16929] AH01067: Failed to read FastCGI header
[Mon Apr 21 00:35:41.697050 2025] [proxy_fcgi:error] [pid 2831:tid 2882] (104)Connection reset by peer: [remote 189.28.77.151:16929] AH01075: Error dispatching request to :887:
[Mon Apr 21 00:41:54.624401 2025] [autoindex:error] [pid 2937:tid 2965] [client 185.242.226.43:38918] AH01276: Cannot serve directory /www/server/phpmyadmin/: No matching DirectoryIndex (index.php,index.html,index.htm,default.php,default.html,default.htm) found, and server-generated directory index forbidden by Options directive
[Mon Apr 21 00:42:11.744601 2025] [proxy_fcgi:error] [pid 2831:tid 2842] [remote 189.28.77.151:16946] AH01067: Failed to read FastCGI header
[Mon Apr 21 00:42:11.744654 2025] [proxy_fcgi:error] [pid 2831:tid 2842] (104)Connection reset by peer: [remote 189.28.77.151:16946] AH01075: Error dispatching request to :887:
[Mon Apr 21 00:45:11.817934 2025] [proxy_fcgi:error] [pid 2831:tid 2847] [remote 189.28.77.151:16946] AH01067: Failed to read FastCGI header
[Mon Apr 21 00:45:11.818535 2025] [proxy_fcgi:error] [pid 2831:tid 2847] (104)Connection reset by peer: [remote 189.28.77.151:16946] AH01075: Error dispatching request to :887:
[Mon Apr 21 00:50:31.791169 2025] [proxy_fcgi:error] [pid 2831:tid 2844] [remote 189.28.77.151:16938] AH01067: Failed to read FastCGI header
[Mon Apr 21 00:50:31.791223 2025] [proxy_fcgi:error] [pid 2831:tid 2844] (104)Connection reset by peer: [remote 189.28.77.151:16938] AH01075: Error dispatching request to :887:
[Mon Apr 21 03:58:28.036712 2025] [autoindex:error] [pid 2832:tid 2918] [client 206.168.34.119:36824] AH01276: Cannot serve directory /www/server/phpmyadmin/: No matching DirectoryIndex (index.php,index.html,index.htm,default.php,default.html,default.htm) found, and server-generated directory index forbidden by Options directive
[Mon Apr 21 03:58:34.103866 2025] [autoindex:error] [pid 2832:tid 2920] [client 206.168.34.119:43340] AH01276: Cannot serve directory /www/server/phpmyadmin/: No matching DirectoryIndex (index.php,index.html,index.htm,default.php,default.html,default.htm) found, and server-generated directory index forbidden by Options directive
[Mon Apr 21 05:02:55.530658 2025] [autoindex:error] [pid 2937:tid 2967] [client 167.94.138.52:59932] AH01276: Cannot serve directory /www/server/phpmyadmin/: No matching DirectoryIndex (index.php,index.html,index.htm,default.php,default.html,default.htm) found, and server-generated directory index forbidden by Options directive
[Mon Apr 21 05:03:03.629905 2025] [autoindex:error] [pid 2832:tid 2921] [client 167.94.138.52:42984] AH01276: Cannot serve directory /www/server/phpmyadmin/: No matching DirectoryIndex (index.php,index.html,index.htm,default.php,default.html,default.htm) found, and server-generated directory index forbidden by Options directive
[Mon Apr 21 06:35:39.891898 2025] [autoindex:error] [pid 2937:tid 2979] [client 162.142.125.203:38024] AH01276: Cannot serve directory /www/server/phpmyadmin/: No matching DirectoryIndex (index.php,index.html,index.htm,default.php,default.html,default.htm) found, and server-generated directory index forbidden by Options directive
[Mon Apr 21 06:35:43.904546 2025] [autoindex:error] [pid 2832:tid 2931] [client 162.142.125.203:46524] AH01276: Cannot serve directory /www/server/phpmyadmin/: No matching DirectoryIndex (index.php,index.html,index.htm,default.php,default.html,default.htm) found, and server-generated directory index forbidden by Options directive
[Mon Apr 21 08:54:53.992748 2025] [autoindex:error] [pid 2937:tid 2985] [client 199.45.154.159:42178] AH01276: Cannot serve directory /www/server/phpmyadmin/: No matching DirectoryIndex (index.php,index.html,index.htm,default.php,default.html,default.htm) found, and server-generated directory index forbidden by Options directive
[Mon Apr 21 08:54:58.855528 2025] [autoindex:error] [pid 2990:tid 3024] [client 199.45.154.159:45526] AH01276: Cannot serve directory /www/server/phpmyadmin/: No matching DirectoryIndex (index.php,index.html,index.htm,default.php,default.html,default.htm) found, and server-generated directory index forbidden by Options directive
[Mon Apr 21 13:19:36.693422 2025] [proxy_fcgi:error] [pid 2831:tid 2847] [remote 189.28.77.151:43183] AH01067: Failed to read FastCGI header
[Mon Apr 21 13:19:36.693468 2025] [proxy_fcgi:error] [pid 2831:tid 2847] (104)Connection reset by peer: [remote 189.28.77.151:43183] AH01075: Error dispatching request to :887: !<

Look at the last two lines, I think that's where the problem lies.

aaP_clous

I made the following changes and now I can download the 1.4 GB database using phpmyadmin (it seems like my server connection broke down earlier) :

php 8.2 configuration

I changed this part too;

.. and after that I changed the 'Configuration file'

output_buffering = 4096
zlib.output_compression = On

..... finally restarted the server and my large database can now be downloaded via phpmyadmin

aaPanel_Kern

Hello, thanks for the solution

aaP_clous

I tested where exactly the problem is in all the changes I made and I found it.
I think that option should be set better by default so that people who have large databases and want to gzip them don't have this problem.

I reinstalled a fresh Ubuntu 22.04, after that I installed aapanel wirh: Apache, MariaDB, Pure-Ftpd and Phpmyadmin 5.2
After that I changed this option from php 8.2

I set it to 480 seconds, which is 8 minutes. I think the default is 60 seconds, which is very short.
I recommend that you raise this number by default to 8 or 10 min. that way, people who have large and heavy databases will not have problems through phpmyadmin.

After this change, I restarted the server and no longer had any problems downloading the 1.4 GB database.

aaP_demo1

aaP_clous
Alternative way, you can always click on the backup from database management. It is faster.

aaP_clous

aaP_demo1

Thanks for your reply. I wanted to do a backup via phpmyadmin.