Title: Database-Backup causes (memory) Errors Last modified: September 28, 2020 --- # Database-Backup causes (memory) Errors * Resolved [dd005](https://wordpress.org/support/users/dd005/) * (@dd005) * [5 years, 6 months ago](https://wordpress.org/support/topic/database-backup-causes-memory-errors/) * Hi, * I have the following issue with backing up my Database. * 1) When I try to use the One-Click-Database-Backup, there happens either nothing or I get a whitescreen with a 503 Service Unavailable Error. * 2) When I create a job that is supposed to create a backup of only the database, I recieve errors (see below for the log.) With regard to the memory size exhausted: I had issues with memory-size errors sometime ago, but I resolved them by setting the Memory to 512 MB. * I tried to disable all plugins in troubleshooting mode, which interestingly made the One-Click-Database-Backup work. As soon as I activated the plugins (once I had about 17-20 of 23 in total activated), it stopped working. I tried to identify a specific plugin, but it seems to occur as soon as enough plugins are active and not in relation to a single one. * Thanks in advance! * — [INFO] BackWPup 3.7.1; Ein Projekt der Inpsyde GmbH [INFO] WordPress 5.5.1 auf [https://website.de/](https://website.de/) [INFO] Log-Level: Normal (übersetzt)[ INFO] BackWPup-Auftrag: Test-only Backup [INFO] Logfile ist: backwpup_log_a55663_2020- 09-28_17-58-50.html [INFO] Backup-Datei ist: 2020-09-28_17-58-50_5F4DH42604.zip[ 28-Sep-2020 17:58:50] 1. Versuche, die Datenbank zu sichern … [28-Sep-2020 17: 58:50] Mit Datenbank d02 auf localhost verbunden [28-Sep-2020 17:58:51] FEHLER: Allowed memory size of 536870912 bytes exhausted (tried to allocate 111848096 bytes) [28-Sep-2020 17:58:52] 2. Versuche, die Datenbank zu sichern … [28-Sep- 2020 17:58:52] Mit Datenbank d02 auf localhost verbunden [28-Sep-2020 17:58:52] FEHLER: Allowed memory size of 536870912 bytes exhausted (tried to allocate 111848096 bytes) [28-Sep-2020 17:58:53] 3. Versuche, die Datenbank zu sichern … [28-Sep- 2020 17:58:53] Mit Datenbank d02 auf localhost verbunden [28-Sep-2020 17:58:54] Datenbank-Backup „d02.sql“ mit 208,30 MB zur Backup-Datei-Liste hinzugefügt [ 28-Sep-2020 17:58:54] Datenbank-Backup fertig! [28-Sep-2020 17:58:54] 1. Versuche, eine Manifest-Datei zu generieren … [28-Sep-2020 17:58:54] Die Datei manifest. json mit 4,23 kB wurde zur Backup-Datei-Liste hinzugefügt. [28-Sep-2020 17:58: 54] 1. Versuche, Backup-Archiv zu erstellen … [28-Sep-2020 17:58:54] Komprimiere Dateien als ZipArchive. Bitte habe einen Moment Geduld. [28-Sep-2020 17:59:15] Backup wurde erstellt. [28-Sep-2020 17:59:15] Archivgröße ist 29,68 MB. [28-Sep- 2020 17:59:15] 3 Dateien mit 208,30 MB im Archiv. [28-Sep-2020 17:59:16] FEHLER: Job mit Fehlern beendet in 26 Sekunden. Um eine korrekte Ausführung zu gewährleisten, musst du die Fehler beheben. Viewing 4 replies - 1 through 4 (of 4 total) * [happyAnt](https://wordpress.org/support/users/duongcuong96/) * (@duongcuong96) * [5 years, 6 months ago](https://wordpress.org/support/topic/database-backup-causes-memory-errors/#post-13468710) * Hello [@dd005](https://wordpress.org/support/users/dd005/) during the backup process running, maybe there are other plugins also running too, and cost more memory. in this case, I would recommend you to keep increase the max memory limit allowed, maybe 700 MB should be fine. You can increase the memory limit for ** admin tasks only**, by define WP_MAX_MEMORY_LIMIT: In your wp-config.php file: Add this to the top, before the line that says, “Happy Blogging”: `define('WP_MAX_MEMORY_LIMIT',' 700M');` * Thread Starter [dd005](https://wordpress.org/support/users/dd005/) * (@dd005) * [5 years, 6 months ago](https://wordpress.org/support/topic/database-backup-causes-memory-errors/#post-13469384) * Hello [@duongcuong96](https://wordpress.org/support/users/duongcuong96/), * thanks a lot! It actually fixed the One-Click-Backup. When running a usual backup, however, I receive a lot of those warnings (until the backup is aborted): * WARNUNG: Error while sending QUERY packet. PID=22074 * What to do about this now? * Thanks for your help! * [happyAnt](https://wordpress.org/support/users/duongcuong96/) * (@duongcuong96) * [5 years, 6 months ago](https://wordpress.org/support/topic/database-backup-causes-memory-errors/#post-13469906) * [@dd005](https://wordpress.org/support/users/dd005/) `WARNUNG: Error while sending QUERY packet. PID=22074` hmm this was returned from MySQL server, please contact your hoster then ask them about this ^^ TY! * [happyAnt](https://wordpress.org/support/users/duongcuong96/) * (@duongcuong96) * [5 years, 5 months ago](https://wordpress.org/support/topic/database-backup-causes-memory-errors/#post-13538704) * [@dd005](https://wordpress.org/support/users/dd005/) * since we haven’t heard back from you, I’m going to mark it as resolved. If you’re still having problems, feel free to let us know ;), * Btw, If you find BackWPUp is useful for you, we would really appreciate it. if you leave a positive review and rating. This would encourage us to develop new free features and provide free support 😀 [https://wordpress.org/support/plugin/backwpup/reviews/](https://wordpress.org/support/plugin/backwpup/reviews/) Viewing 4 replies - 1 through 4 (of 4 total) The topic ‘Database-Backup causes (memory) Errors’ is closed to new replies. * ![](https://ps.w.org/backwpup/assets/icon-256x256.png?rev=3236141) * [BackWPup – WordPress Backup & Restore Plugin](https://wordpress.org/plugins/backwpup/) * [Support Threads](https://wordpress.org/support/plugin/backwpup/) * [Active Topics](https://wordpress.org/support/plugin/backwpup/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/backwpup/unresolved/) * [Reviews](https://wordpress.org/support/plugin/backwpup/reviews/) * 4 replies * 2 participants * Last reply from: [happyAnt](https://wordpress.org/support/users/duongcuong96/) * Last activity: [5 years, 5 months ago](https://wordpress.org/support/topic/database-backup-causes-memory-errors/#post-13538704) * Status: resolved