Backup creation failed

Hi @jochenklein

Overall, it seem like your website is using the same database like your other sites, which is very dangerous.

That’s the reason why the backup failed as well, as the database dump took too much time, in any case we have method that should handle it.

Your latest debug code indicates that the process failed due to manual cancel, most likely you clicked on “Stop Backup Process” and then forced both processes to stop before stop action could affect the process.
– In short, if you would run it once again, it should go further.

In premium extension, there is option to exclude tables from different sites, which would also fix the issue with backup, but in your case you need to backup all tables even these that are not related to your website.
– Which means, during restoration all these tables will be replaced with currently available ones, which may also affect other sites.

Here you can find complete solution:

Your backup failed during database export, mostly due to its huge size.

In first place I’d recommend you to perform full cleanup and optimize all your tables.
You can do that easily with help of free and simple plugin.
Check it out: https://wordpress.org/plugins/advanced-database-cleaner

Then, follow these steps carefully:

1. Download and install “Advanced DB Cleanup” plugin
2. Do full Cleanup and optimize all tables using Advanced DB Cleanup plugin
3. After that you can already remove mentioned cleanup plugin if you wish
4. Go to Backup & Migration plugin settings
5. Open “Other options” section
6. Disable PHP CLI checking: https://prnt.sc/1sljr31
7. Change backup method: https://prnt.sc/1s1ofpa
8. Enable database batch export: https://prnt.sc/bn7MjTUxHuEe
9. Save “Other options” section
10. Force to end both processes (troubleshooting): https://prnt.sc/1trv1tm

Right after the last step, you can run the backup process once again.

Let me know if that resolves your issue 🙂
Thank you!

Hi @jochenklein

My apologies for delayed reply.

Yes if you’re 100% sure that these tables are not in use anymore, you can safely remove them via mentioned plugin by me. There is option to remove tables.

Let me know if you need further assistance 🙂
Thank you!