Split: Error When Backing Up: Table postmeta has very many rows

[Laurence PAULParticipant]

Hi, I am trying backup database with big wp_postmeta :
Table wp_postmeta: Total expected rows (approximate): 2032168

I have set this to my wp-config.php
define(‘UPDRAFTPLUS_ALWAYS_TRY_MYSQLDUMP’, true);
define(‘UPDRAFTPLUS_MYSQLDUMP_EXECUTABLE’, ‘/usr/bin/mysqldump’);

I try into a php file :
exec(‘/usr/bin/mysqldump –user=”xxx” –password=”xxx” xxx > xxx.sql’)

With success, so why updraftplus does not user constants instructions ?

I have this message, again and again when I try to backup :

Backups in progress:
Mon, November 20, 2017 14:55 – next resumption: 4 (after -5s) – show log – stop
Creating database backup (table: wp_postmeta)

[Dee NutbourneModerator]

Hi,

Apologies for the delay.

Please could you send us a copy of the latest backups log? This can be found in the Existing Backups tab.

The contents will be too long to post here directly, but you can use an online service such as Pastebin or Dropbox, and post the link here.

Best Wishes,
David N

[Author]

Posts