Backup failed

Hi @mikkelzyber

Your postmeta table is quite large, it may take time to process it.
Increasing query output may help you to speed up the process before your web server cancel it.

Please try out these solution:
1. Go to “Other options” section
2. Change backup method: https://prnt.sc/1s1ofpa
3. Disable PHP CLI checking: https://prnt.sc/1sljr31
4. Modify query output: https://prnt.sc/1trxucl (set this value to 3000)
5. Save “Other options” section
6. Force stop both processes: https://prnt.sc/1trv1tm

When you do that, try to run your backup once again.

Let me know if that worked for you 🙂
Thank you!

Hi @mikkelzyber

Sorry to hear that, for now there are only two things that you can try.

1. Do full Cleanup and optimize all tables using Advanced DB Cleanup plugin
– https://ww.wp.xz.cn/plugins/advanced-database-cleaner/
2. Once done, try to run your backup again

Clean-up should make the tables smaller in size, which may will help to dump them in limited time.

The second solution would be to wait for new version of the plugin, we’re working on batching method that would bypass time limitations for database export. Estimation for usable beta with this feature would be for next week. It will contain dedicated solution for this kind of issue.

In the meanwhile you can also analyze your database overall, I can see your database takes almost 2 GB and contain 193 tables, it’s quite large amount for a WordPress website, check if there are tables that are not related to your website and make sure you have only tables with your prefix declared in wp-config.php.

I’ll give your URL of mentioned beta in this topic once it will be ready.