Hi Charlie read the following URL it might help you with your issue.
Regards
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
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?
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
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?
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
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)
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
Hi Charlie have you spoken to your sever administrator in regards to this issue?
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
Hi @csavage can you also mark this support as resolved.
Thank you
