Problem with backing up a large database

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

My topic similar to How does it behave for very large remote databases?
but no answers.

Hello Gregory,

Thank you for your message.

To resolve the issue, please follow the recommendations in this guide:

Recommendation for backing up large databases using SQLBackupAndFTP

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

Hello Gregory,

Thank you for your response and details.

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

phpMyAdmin_SQlBackupAndFTP

I can’t use MySQL Server (TCP/IP), I don’t have permissions.
I have to use another backup method e.g. WordPress plugin.

Thank you for your response.

Unfortunately, without permissions to use the MySQL Server (TCP/IP) connection, it is not possible to back up your database using SQLBackupAndFTP.