I have a large SQL database (one table contains one million records).
When I make a backup (v. 12.7.28), I don’t get a full copy.
At the end of the SQL file I have the message:
“The dynamic response body size is over the limit, the response will be truncated by the web server. The limit is set in the key ‘maxDynRespSize’ located in the tuning section of the server configuration, and labeled ‘max dynamic response body size’.”
I will add that the program does not give any message that the entire database has not been backed up. I thought everything was OK until I looked at the SQL file.
How to make a full copy?
Is it possible?
ps.
My server: [notice]server info fcgi:Off max execution time: 300 wp version:6.6.2 php version:7.4.33 db version:5.5.5 php ini:safe_mode: memory_limit:512M memory_get_usage:17.72 MB memory_get_peak_usage:18.59 MB extensions:PDO enabled curl enabled zlib enabled is_multisite:0
I’m trying to make a copy of the SQL WordPress database.
As a ‘Server type’ I chose ‘MySQL Server (phpMyAdmin)’
and
I checked the option “Backup one DB, send, repeat (as opposite to backup all, then send all)”, but nothing changed. I still only get 30% of the sql-file with the information at the end “The dynamic response body size is over the limit, the response will be truncated by the web server. The limit is set in the key ‘maxDynRespSize’ located in the tuning section of the server configuration, and labeled ‘max dynamic response body size’.”
If I export the database via phpMyAdmin the effect is the same as with your program (only 30% + comment at the end of the file).
Currently, due to the numerous different versions of phpMyAdmin, we are unable to provide support when the MySQL Server (phpMyAdmin) connection method is used. Instead, we recommend using the MySQL Server (TCP/IP) connection type for a more reliable connection. If the MySQL port (3306) is not accessible, you can connect via an SSH tunnel using the SSH port (22).
