MySQL server has gone away

Suggestion: add a newline before each [DATE] so copy/paste is easier to read.

Bug: During making large zip file, MySQL closes and the plugin doesn’t reconnect.

Bug: leaves huge temporary files behind. backwpup_full_2013-12-27_22-42-20.zip (1,961,275,681 bytes) and backwpup_full_2013-12-27_22-42-20.zip.pIQsxY (1,517,737,034 bytes)

Bug: Screen displays 20% done, after 12 hours.

Bug: After aborting a job, then starting that job, it continues with 20% done (then displays 21%), with same “WARNING: mysql_error() expects parameter 1 to be resource, boolean given”. Should start over. (When I manually delete the temp files, it starts over as expected.)

[INFO] BackWPup version 3.1.1; A project of Inpsyde GmbH [INFO] WordPress version 3.8 [INFO] Blog url: https://lernerconsulting.info/ [INFO] BackWPup job: Full Backup; DBDUMP+FILE+WPEXP+WPPLUGIN [INFO] BackWPup no automatic job start configured [INFO] BackWPup job started manually [INFO] PHP ver.: 5.3.24; cgi-fcgi; Linux [INFO] Maximum PHP script execution time is 3600 seconds [INFO] Script restarts on every main step is activated [INFO] MySQL ver.: 5.5.30-cll [INFO] curl ver.: 7.24.0; OpenSSL/0.9.8b [INFO] Temp folder is: /home/USERNAME/public_html/uploads/backwpup-dc42cf-temp/ [INFO] Logfile is: /home/USERNAME/public_html/wp-content/backwpup-ec9bf-logs/backwpup_log_dc42cf_2013-12-27_22-42-20.html [INFO] Backup type is: archive [INFO] Backup file is: /home/USERNAME/logs/backwpup_full_2013-12-27_22-42-20.zip

[27-Dec-2013 22:42:43] 5943 folders to backup.
[27-Dec-2013 22:42:43] Restart will be executed now.
[27-Dec-2013 22:42:43] 1. Trying to create a WordPress export to XML file …
[27-Dec-2013 22:42:43] Check WP Export file …
[27-Dec-2013 22:42:43] WP Export file is a valid WXR file.
[27-Dec-2013 22:42:43] Compressing file …
[27-Dec-2013 22:42:43] Compressing done.
[27-Dec-2013 22:42:43] Added XML export "USERNAME-Consulting-Dashboard.wordpress.2013-12-27.xml.gz" with 5.46 kB to backup file list.
[27-Dec-2013 22:42:43] 1. Trying to generate a file with installed plugin names …
[27-Dec-2013 22:42:43] Added plugin list file "USERNAME-Consulting-Dashboard.pluginlist.2013-12-27.txt.gz" with 748.00 B to backup file list.
[27-Dec-2013 22:42:43] 1. Trying to generate a manifest file …
[27-Dec-2013 22:42:43] Added manifest.json file with 5.06 kB to backup file list.
[27-Dec-2013 22:42:43] 1. Trying to create backup archive …
[27-Dec-2013 22:42:43] Compressing files as ZipArchive. Please be patient, this may take a moment.
[27-Dec-2013 22:42:43] WARNING: Link "/home/USERNAME/public_html/clickbankdb" not following.
[27-Dec-2013 22:42:43] WARNING: Link "/home/USERNAME/public_html/shared" not following.
[27-Dec-2013 22:42:43] WARNING: Link "/home/USERNAME/public_html/socialbookmarkscript" not following.
[27-Dec-2013 22:42:43] WARNING: Link "/home/USERNAME/public_html/styles" not following.
[28-Dec-2013 08:58:20 UTC] WordPress database error MySQL server has gone away for query SELECT 1 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, BackWPup_Cron::cron_active, BackWPup_Job::start_http, BackWPup_Job->run, BackWPup_Job->create_archive, BackWPup_Job->update_working_data
[28-Dec-2013 09:09:56 UTC] WordPress database error MySQL server has gone away for query SELECT 1 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, BackWPup_Cron::cron_active, BackWPup_Job::start_http, BackWPup_Job->run, BackWPup_Job->create_archive, BackWPup_Job->update_working_data
[28-Dec-2013 09:16:22 UTC] WordPress database error MySQL server has gone away for query SELECT 1 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, BackWPup_Cron::cron_active, BackWPup_Job::start_http, BackWPup_Job->run, BackWPup_Job->create_archive, BackWPup_Job->update_working_data
[28-Dec-2013 02:21:31] WARNING: mysql_error() expects parameter 1 to be resource, boolean given
[28-Dec-2013 09:21:31 UTC] PHP Warning: mysql_error() expects parameter 1 to be resource, boolean given in /home/USERNAME/public_html/wp-includes/wp-db.php on line 1220
[28-Dec-2013 02:22:32] WARNING: mysql_error() expects parameter 1 to be resource, boolean given
[28-Dec-2013 09:22:32 UTC] PHP Warning: mysql_error() expects parameter 1 to be resource, boolean given in /home/USERNAME/public_html/wp-includes/wp-db.php on line 1220
[28-Dec-2013 02:23:28] WARNING: mysql_error() expects parameter 1 to be resource, boolean given
[28-Dec-2013 09:23:28 UTC] PHP Warning: mysql_error() expects parameter 1 to be resource, boolean given in /home/USERNAME/public_html/wp-includes/wp-db.php on line 1220
[28-Dec-2013 02:24:10] WARNING: mysql_error() expects parameter 1 to be resource, boolean given
[28-Dec-2013 09:24:10 UTC] PHP Warning: mysql_error() expects parameter 1 to be resource, boolean given in /home/USERNAME/public_html/wp-includes/wp-db.php on line 1220
[28-Dec-2013 02:25:01] WARNING: mysql_error() expects parameter 1 to be resource, boolean given
[28-Dec-2013 09:25:01 UTC] PHP Warning: mysql_error() expects parameter 1 to be resource, boolean given in /home/USERNAME/public_html/wp-includes/wp-db.php on line 1220
[28-Dec-2013 02:25:49] WARNING: mysql_error() expects parameter 1 to be resource, boolean given
[28-Dec-2013 09:25:49 UTC] PHP Warning: mysql_error() expects parameter 1 to be resource, boolean given in /home/USERNAME/public_html/wp-includes/wp-db.php on line 1220
[28-Dec-2013 02:26:37] WARNING: mysql_error() expects parameter 1 to be resource, boolean given
[28-Dec-2013 09:26:37 UTC] PHP Warning: mysql_error() expects parameter 1 to be resource, boolean given in /home/USERNAME/public_html/wp-includes/wp-db.php on line 1220