Backups keep hanging

[cm6Participant]

I am trying to do a migration from one site to another and whenever I try to do a full backup it keeps hanging at this one location. It stays here and never advances to finish the backup: Creating database backup (table: wp_uuxg_hw_snapshots).

Here is a link to the log file: https://www.dropbox.com/s/0pc2a1wgwn926h5/log.30d8701a0876.txt?dl=0

[Dee NutbourneModerator]

Hi,

Apologies for the delay.

This suggests that there when rows are read from that table, the result is larger than the available PHP memory, and that PHP is crashing when reading that table as a result.

Here’s how to increase PHP memory: https://updraftplus.com/faqs/deal-fatal-error-allowed-memory-size-errors/

Or, to tell UpdraftPlus that it can skip that table’s data (it seems to be some sort of backup, so perhaps redundant?), add this near the top of your wp-config.php:

define('UPDRAFTPLUS_DATA_OPTIONAL_TABLES', 'bwps_log,statpress,slim_stats,redirection_logs,
Counterize,Counterize_Referers,Counterize_UserAgents,
wbz404_logs,wbz404_redirects,tts_trafficstats,
tts_referrer_stats,wponlinebackup_generations,
svisitor_stat,simple_feed_stats,itsec_log,
relevanssi_log,hw_snapshots');

(That line adds the table to the default list, rather than removing the default list).

Best Wishes,
David N

[Author]

Posts