Title: Error on DB Backup Last modified: August 30, 2016 --- # Error on DB Backup * Resolved [SheerHeartAttack](https://wordpress.org/support/users/sheerheartattack/) * (@sheerheartattack) * [11 years ago](https://wordpress.org/support/topic/error-on-db-backup/) * When I try to create a DB backup through this plugin, I get the following error: * `Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 31122351 bytes) in ~/wp-content/plugins/all-in-one-wp-security-and-firewall/classes/ wp-security-backup.php on line 64` * I also have a different plugin that makes backups, and when I go to that plugin in the WP dashboard I see the following error: * `mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table '[prefix]_aiowps_global_meta' at row: 0` * So the error does seem to be stemming from AIOWPS. Increasing my overall WP memory limit doesn’t help. I’ve contacted my server and they believe this is a limit set within this plugin. Is there anything I can change to increase the memory limit? Or maybe decrease the size of this table? * Thank you! * [https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/) Viewing 11 replies - 1 through 11 (of 11 total) * Plugin Contributor [mbrsolution](https://wordpress.org/support/users/mbrsolution/) * (@mbrsolution) * [11 years ago](https://wordpress.org/support/topic/error-on-db-backup/#post-6468538) * Hi, if you increase your website memory to lets say 256 MB you won’t run into the above error and your WordPress website will run better. Try that and see how you go. * Regards * Thread Starter [SheerHeartAttack](https://wordpress.org/support/users/sheerheartattack/) * (@sheerheartattack) * [11 years ago](https://wordpress.org/support/topic/error-on-db-backup/#post-6468554) * Yes, I already did that — it was increased to 1024mb with no change. Still got the error. * Plugin Contributor [mbrsolution](https://wordpress.org/support/users/mbrsolution/) * (@mbrsolution) * [11 years ago](https://wordpress.org/support/topic/error-on-db-backup/#post-6468610) * Hi you have plenty of memory so that is definitely not the problem. However you might want to speak to your host in regards to the following error… * > Got packet bigger than ‘max_allowed_packet’ * Your host will have to increase the following **max_allowed_packet** in the Server. * Thread Starter [SheerHeartAttack](https://wordpress.org/support/users/sheerheartattack/) * (@sheerheartattack) * [11 years ago](https://wordpress.org/support/topic/error-on-db-backup/#post-6468669) * Yup, we tried that. The max_allowed_packet size is set to 500M and 512M for mysqldump but we’re still getting this error. * Plugin Contributor [mbrsolution](https://wordpress.org/support/users/mbrsolution/) * (@mbrsolution) * [11 years ago](https://wordpress.org/support/topic/error-on-db-backup/#post-6468670) * Can you disable all your other plugins except this one. Try and create another backup. * Plugin Contributor [wpsolutions](https://wordpress.org/support/users/wpsolutions/) * (@wpsolutions) * [11 years ago](https://wordpress.org/support/topic/error-on-db-backup/#post-6468672) * > I’ve contacted my server and they believe this is a limit set within this plugin. * No that’s not true. The AIOWPS doesn’t set any limits for memory. * > Yes, I already did that — it was increased to 1024mb with no change * If you are still getting the memory exhausted error then obviously the memory increase is not being applied correctly. Where did they set the increased memory_limit? Perhaps there are multiple areas on your server where this value is being defined?? * Thread Starter [SheerHeartAttack](https://wordpress.org/support/users/sheerheartattack/) * (@sheerheartattack) * [11 years ago](https://wordpress.org/support/topic/error-on-db-backup/#post-6468696) * The memory limit is set within wp-config.php. Is there anywhere else I can look for a separate setting? * My other backup plugin seems to be working now, so I don’t understand why this one wouldn’t be. * I would prefer not to disable all other plugins since we don’t have a separate testing site, only the live one. * Plugin Contributor [mbrsolution](https://wordpress.org/support/users/mbrsolution/) * (@mbrsolution) * [11 years ago](https://wordpress.org/support/topic/error-on-db-backup/#post-6468736) * Hi did you speak to your host about this memory issue? * Thread Starter [SheerHeartAttack](https://wordpress.org/support/users/sheerheartattack/) * (@sheerheartattack) * [11 years ago](https://wordpress.org/support/topic/error-on-db-backup/#post-6468742) * Yes, as I noted above. * Plugin Contributor [mbrsolution](https://wordpress.org/support/users/mbrsolution/) * (@mbrsolution) * [11 years ago](https://wordpress.org/support/topic/error-on-db-backup/#post-6468743) * In regards to your comment above. * > The memory limit is set within wp-config.php. Is there anywhere else I can > look for a separate setting? * The memory limit also needs for the server to allow your website to utilize that amount of memory. * If you still get the same error message then a server setting might need some attention. * Plugin Contributor [mbrsolution](https://wordpress.org/support/users/mbrsolution/) * (@mbrsolution) * [10 years, 6 months ago](https://wordpress.org/support/topic/error-on-db-backup/#post-6468782) * I am marking this thread as resolved. No reply in 5 months. * Thank you Viewing 11 replies - 1 through 11 (of 11 total) The topic ‘Error on DB Backup’ is closed to new replies. * ![](https://ps.w.org/all-in-one-wp-security-and-firewall/assets/icon-256x256. png?rev=2798307) * [All-In-One Security (AIOS) – Security and Firewall](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/) * [Frequently Asked Questions](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/#faq) * [Support Threads](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/) * [Active Topics](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/unresolved/) * [Reviews](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/reviews/) * 11 replies * 3 participants * Last reply from: [mbrsolution](https://wordpress.org/support/users/mbrsolution/) * Last activity: [10 years, 6 months ago](https://wordpress.org/support/topic/error-on-db-backup/#post-6468782) * Status: resolved