Title: Database Backups Not Being Made Last modified: August 22, 2016 --- # Database Backups Not Being Made * Resolved [Charles Savage](https://wordpress.org/support/users/csavage/) * (@csavage) * [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-not-being-made/) * I am unable to get database backups to occur, either manual or scheduled. On manual backups, the symptom is that I get a largely blank page after clicking“ Create DB Backup now”. No zip files have appeared in wp-content/plugins/all-in- one-wp-security-and-firewall/backups. The wp-security-log-cron-job.txt file shows a series of “Hourly cron handler got fired… Checking if a backup needs to be done now” messages. The WP database is quite large. How can I troubleshoot this further, or what should I look for? * – Charlie * [https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/) Viewing 13 replies - 1 through 13 (of 13 total) * Plugin Contributor [mbrsolution](https://wordpress.org/support/users/mbrsolution/) * (@mbrsolution) * [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-not-being-made/#post-5619342) * Hi Charlie read the following [URL ](https://wordpress.org/support/topic/automated-backups) it might help you with your issue. * Regards * 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-5619367) * Thank you. That is an interesting post, but animagic’s problem never got resolved. In my case, the cron job is firing and is logging events in the wp-security-log- cron-job.txt file, but no backup file appears in the backups folder. Manual backups by All-In-One do not work either. I can use mysqldump from a command line okay. The environment is a single Apache web server hosting one WordPress site with MySQL installed locally on the same server. Could it be a PHP problem? * – Charlie * Plugin Contributor [mbrsolution](https://wordpress.org/support/users/mbrsolution/) * (@mbrsolution) * [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-not-being-made/#post-5619376) * Hi Charlie, when you say… * > installed locally on the same server. Could it be a PHP problem? * Are you running your website locally in your laptop or tower? * 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-5619385) * Hello! * By “locally” I meant that the MySQL server with the WP database is on the same server as the WordPress site, unlike the situation that animagic posted about earlier. The server is a virtual machine at Codero. It is not physically in my office, but the VM is all mine; it does not host anything else. * – Charlie * Plugin Contributor [wpsolutions](https://wordpress.org/support/users/wpsolutions/) * (@wpsolutions) * [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-not-being-made/#post-5619388) * Hi Charlie, Can you please check your server logs to see if there are any entries pertaining to the issue you are having? (If you are unable to find your server log file ask your host provider to help you) * Also, have you checked the “wp-security-log.txt” file? * 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 * Plugin Contributor [wpsolutions](https://wordpress.org/support/users/wpsolutions/) * (@wpsolutions) * [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-not-being-made/#post-5619394) * When you say “database is quite large”, how many tables do you have? Of those tables, what figures are we talking about when it comes to number of rows for the larger tables? * (I wonder if the backup function is timing out in your case due to the sheer number of rows it has to cycle through when constructing the backup file) * 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 * Plugin Contributor [mbrsolution](https://wordpress.org/support/users/mbrsolution/) * (@mbrsolution) * [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-not-being-made/#post-5619552) * Hi Charlie have you spoken to your sever administrator in regards to this issue? * 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) * Plugin Contributor [mbrsolution](https://wordpress.org/support/users/mbrsolution/) * (@mbrsolution) * [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-not-being-made/#post-5619560) * Hi [@csavage](https://wordpress.org/support/users/csavage/) can you also mark this support as resolved. * Thank you * 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. * 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) Viewing 13 replies - 1 through 13 (of 13 total) The topic ‘Database Backups Not Being Made’ 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/) ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * [db](https://wordpress.org/support/topic-tag/db/) * 13 replies * 3 participants * Last reply from: [Charles Savage](https://wordpress.org/support/users/csavage/) * Last activity: [11 years, 4 months ago](https://wordpress.org/support/topic/database-backups-not-being-made/#post-5619562) * Status: resolved