Title: Charles Savage's Replies | WordPress.org --- # Charles Savage [ ](https://wordpress.org/support/users/csavage/) * [Profile](https://wordpress.org/support/users/csavage/) * [Topics Started](https://wordpress.org/support/users/csavage/topics/) * [Replies Created](https://wordpress.org/support/users/csavage/replies/) * [Reviews Written](https://wordpress.org/support/users/csavage/reviews/) * [Topics Replied To](https://wordpress.org/support/users/csavage/replied-to/) * [Engagements](https://wordpress.org/support/users/csavage/engagements/) * [Favorites](https://wordpress.org/support/users/csavage/favorites/) Search replies: ## Forum Replies Created Viewing 15 replies - 1 through 15 (of 17 total) 1 [2](https://wordpress.org/support/users/csavage/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/csavage/replies/page/2/?output_format=md) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[All-In-One Security (AIOS) – Security and Firewall] AIOWPS DB Backup When Number of Backup Files To Keep Exeeds Limit](https://wordpress.org/support/topic/aiowps-db-backup-when-number-of-backup-files-to-keep-exeeds-limit/) * Thread Starter [Charles Savage](https://wordpress.org/support/users/csavage/) * (@csavage) * [11 years, 2 months ago](https://wordpress.org/support/topic/aiowps-db-backup-when-number-of-backup-files-to-keep-exeeds-limit/#post-5826300) * Hello, * I am following up on this issue. The symptom seems to be the same. I handle it for now by manually deleting some of the older backup files so that AIOWPS will create new ones. Is there any fix in sight? * – Charlie * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[All-In-One Security (AIOS) – Security and Firewall] Database Backups Not Being Made](https://wordpress.org/support/topic/database-backups-not-being-made/) * Thread Starter [Charles Savage](https://wordpress.org/support/users/csavage/) * (@csavage) * [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-not-being-made/#post-5619562) * See resolution in: * [https://wordpress.org/support/topic/database-backups-fail](https://wordpress.org/support/topic/database-backups-fail) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[All-In-One Security (AIOS) – Security and Firewall] Database Backups Not Being Made](https://wordpress.org/support/topic/database-backups-not-being-made/) * Thread Starter [Charles Savage](https://wordpress.org/support/users/csavage/) * (@csavage) * [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-not-being-made/#post-5619561) * Oh, good idea. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[All-In-One Security (AIOS) – Security and Firewall] Database Backups Fail](https://wordpress.org/support/topic/database-backups-fail/) * Thread Starter [Charles Savage](https://wordpress.org/support/users/csavage/) * (@csavage) * [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-fail/page/2/#post-5639700) * Yes, it does. Thank you. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[All-In-One Security (AIOS) – Security and Firewall] Database Backups Fail](https://wordpress.org/support/topic/database-backups-fail/) * Thread Starter [Charles Savage](https://wordpress.org/support/users/csavage/) * (@csavage) * [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-fail/#post-5639698) * Perfect! Database backups now work. * I manually created directory **/var/www/html/wp-content/aiowps_backups**, with the same permissions and ownerships as the rest of the site, then clicked the _Create DB Backup Now_ button. The routine ran without failure and did produce a zipped backup file. * The other, previous, change was to set a high enough value for **WP_MAX_MEMORY_LIMIT** in wp-config.php, ahead of the line that invokes wp-settings.php. * Thanks very much for your help. * – Charlie * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[All-In-One Security (AIOS) – Security and Firewall] Database Backups Fail](https://wordpress.org/support/topic/database-backups-fail/) * Thread Starter [Charles Savage](https://wordpress.org/support/users/csavage/) * (@csavage) * [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-fail/#post-5639685) * Darn! That did not work. I deleted just the /backups directory, then tried making a Backup Now. Same _DB Backup failed. Please check the permissions of the backup directory._ * I then created the backups directory again and checked that it was inheriting its permissions from above. Tried Backup Now again and still got _DB Backup failed. Please check the permissions of the backup directory._ * Where is the folder path controlled? I get the impression that AIOWPS is trying to make a directory someplace else. * – Charlie * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[All-In-One Security (AIOS) – Security and Firewall] Database Backups Fail](https://wordpress.org/support/topic/database-backups-fail/) * Thread Starter [Charles Savage](https://wordpress.org/support/users/csavage/) * (@csavage) * [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-fail/#post-5639683) * I still get _DB Backup failed. Please check the permissions of the backup directory._ * The folder ../wp-content/plugins/all-in-one-wp-security-and-firewall/backups and its sub-files was set to 755. Apache was restarted, then _Create DB Backup Now_ tried again. At least it is doing something now but I do get the above message and this is the Apache error log: * PHP Warning: mkdir(): Permission denied in /var/www/html/wp-content/plugins/all- in-one-wp-security-and-firewall/classes/wp-security-utility-file.php on line 386 * Should I try deleting the /backups folder and let AIOWPS remake it? * – Charlie * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[All-In-One Security (AIOS) – Security and Firewall] Database Backups Not Being Made](https://wordpress.org/support/topic/database-backups-not-being-made/) * Thread Starter [Charles Savage](https://wordpress.org/support/users/csavage/) * (@csavage) * [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-not-being-made/#post-5619553) * Unfortunately, I am the server admin. it is my server. * This thread was continued at _Database Backups Fail_ [https://wordpress.org/support/topic/database-backups-fail](https://wordpress.org/support/topic/database-backups-fail) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[All-In-One Security (AIOS) – Security and Firewall] Database Backups Fail](https://wordpress.org/support/topic/database-backups-fail/) * Thread Starter [Charles Savage](https://wordpress.org/support/users/csavage/) * (@csavage) * [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-fail/#post-5639681) * Okay I think we have some progress. When I click on the _Create DB Backup Now_ button, I no longer get a blank page. I get a visible page that says, DB Backup failed. Please check the permissions of the backup directory. * Adding the line… * `define( 'WP_MAX_MEMORY_LIMIT', '384M' );` * …to file /var/www/html/wp-config.php seems to have changed things. What apparently was needed was WP_MAX_MEMORY_LIMIT, not WP_MEMORY_LIMIT. The WP_MAX_MEMORY_LIMIT constant specifically defines the maximum memory limit available when in the administration back-end. * That the page now says something rather just stops dead is an improvement. * As for the message _Please check the permissions of the backup directory_, the backup directory is /var/www/html/wp-content/plugins/all-in-one-wp-security-and- firewall/backups, is that correct? * The AIOWPS/backups directory has the same ownership settings as the rest of the web site. And file attributes are 777. What else could it need? Or is this not the correct directory path? * The Apache error log event associated with this permissions failure is: * > PHP Warning: mkdir(): Permission denied in /var/www/html/wp-content/plugins/ > all-in-one-wp-security-and-firewall/classes/wp-security-utility-file.php on > line 386 * Mkdir()? Is it trying to make a new directory? * – Charlie * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[All-In-One Security (AIOS) – Security and Firewall] Database Backups Fail](https://wordpress.org/support/topic/database-backups-fail/) * Thread Starter [Charles Savage](https://wordpress.org/support/users/csavage/) * (@csavage) * [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-fail/#post-5639659) * Good suggestion. I will pursue those ideas. Will let you know what I get. * – Charlie * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[All-In-One Security (AIOS) – Security and Firewall] Database Backups Fail](https://wordpress.org/support/topic/database-backups-fail/) * Thread Starter [Charles Savage](https://wordpress.org/support/users/csavage/) * (@csavage) * [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-fail/#post-5639656) * I am the host provider; it is my server. * In /etc/php5/apache2/php.ini memory_limit = 384M * In /etc/php5/cli/php.ini memory_limit = 384M * Reported by php –info | grep memory memory_limit => 384M => 384M opcache.memory_consumption => 64 => 64 opcache.preferred_memory_model => no value => no value opcache.protect_memory => 0 => 0 * These were changed from a default value of 128M. I have tied as high as 512M. The changes here do not alter the figure of memory size of 268435456 bytes. * Is there some place else where this limit might be stated? * – Charlie * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[All-In-One Security (AIOS) – Security and Firewall] Database Backups Fail](https://wordpress.org/support/topic/database-backups-fail/) * Thread Starter [Charles Savage](https://wordpress.org/support/users/csavage/) * (@csavage) * [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-fail/#post-5639652) * Any news on this? I did try several more things to change the allocated memory. None so far has changed the size of memory stated in the error message “Allowed memory size of 268435456 bytes exhausted…” * – Charlie * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[All-In-One Security (AIOS) – Security and Firewall] Database Backups Fail](https://wordpress.org/support/topic/database-backups-fail/) * Thread Starter [Charles Savage](https://wordpress.org/support/users/csavage/) * (@csavage) * [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-fail/#post-5639545) * Thank you. I changed define( ‘WP_MEMORY_LIMIT’, ’96M’ ) to define( ‘WP_MEMORY_LIMIT’,‘ 384M’ ) in wp-config.php, then restarted the Apache2 service. The symptoms remain the same — no backup and the memory size stated in the Apache error remains unchanged. * PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 70255224 bytes) in /var/www/html/wp-content/plugins/all-in-one-wp-security-and- firewall/classes/wp-security-backup.php on line 67 * – Charlie * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[All-In-One Security (AIOS) – Security and Firewall] Database Backups Not Being Made](https://wordpress.org/support/topic/database-backups-not-being-made/) * Thread Starter [Charles Savage](https://wordpress.org/support/users/csavage/) * (@csavage) * [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-not-being-made/#post-5619444) * Thanks for following up. * There are 37 tables in the wordpress database. A full backup of the MySQL server( mysqldump) produces an SQL file that 87 MB in size. If this is a time-out problem, where would I find that error message or event? So far no log I have looked at seems to reflect any problem with database backups. Mysqldump from a server command line works well and is very fast. * – Charlie * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[All-In-One Security (AIOS) – Security and Firewall] Database Backups Not Being Made](https://wordpress.org/support/topic/database-backups-not-being-made/) * Thread Starter [Charles Savage](https://wordpress.org/support/users/csavage/) * (@csavage) * [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-not-being-made/#post-5619391) * There is nothing in server logs /var/log/messages, mysql.err or mysql.log. * There are some entries in /var/log/apache2/error.log detailing a missing var in the WP theme, but this does not seem related to MySQL backups. * In wp-security-log.txt there is a series of this message: “FAILURE : Error inserting record into wp_aiowps_login_activity.” The “Error inserting record” events are recent, occurring today. * – Charlie Viewing 15 replies - 1 through 15 (of 17 total) 1 [2](https://wordpress.org/support/users/csavage/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/csavage/replies/page/2/?output_format=md)