WordPress.org

Ready to get started?Download WordPress

Forums

WordPress Backup to Dropbox
[resolved] Max_allowed_packet error (2 posts)

  1. alternateroute
    Member
    Posted 1 year ago #

    I have been getting a huge error log on my site.
    It starts with

    WordPress database error Got a packet bigger than 'max_allowed_packet' bytes for query UPDATE wp_options SET option_value = 'a:8545:{i:0;s:99:\"/
    followed by lots of file names and ends with

    WHERE option_name = 'backup-to-dropbox-processed-files' made by do_action_ref_array, call_user_func_array, run_dropbox_backup, WP_Backup->execute, WP_Backup->backup_path, WP_Backup_Config->add_processed_files, update_option

    I have a relatively large NextGen gallery on my site (3500 images)and I am backing it up.
    It seems like by writing the names of all these files (and the thumbnails) it is exceeding the size allowed in the option table.
    (The backup is frozen at 86%)
    It there a way to stop the plugin recording the names of the files it backs up?
    I will try another backup, excluding the gallery, but longer term it would be nice to be able to do it.
    AJ

    http://wordpress.org/extend/plugins/wordpress-backup-to-dropbox/

  2. Michael De Wildt
    Member
    Plugin Author

    Posted 1 year ago #

    Gday mate,

    Yup, thats an issue. Im going to need to make some changes to fix it.

    In the mean time you could comment out line 68 of class-wp-backup.php:

    $this->config->add_processed_files($current_processed_files);

    This will stop recording the files processed and mean that if you backup falls over it will not know where to restart it.

    Cheers,
    Mikey

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.