Migration failed – max_packet_allowed

Hello,

I have tried for three days to migrate a site from one server to another. Using PHP 7.0 on both. Plugins, Themes, Uploads, Others all work — one at a time. Then UD+ gets stuck on DB file and sets the .maintenance file, and everything just gets worse from there. Then I’m unable. Error is: “0000.185 () Tried to raise max_allowed_packet from 16 MB to 32 MB, but failed (Access denied; you need (at least one of) the SUPER privilege(s) for this operation, b:0;)”.

I have tried changing settings for several variables. There is not one in my PHP.ini file (at least the host interface) for max_allowed_packet.

Our live site has been down for 3 days and is unfortunately losing money now.

Thanks,
Christopher

——————-

0000.002 () Opened log file at time: Thu, 14 Sep 2017 21:08:34 +0000 on https://shepard4port.com/s4p
0000.002 () UpdraftPlus WordPress backup plugin (https://updraftplus.com): 2.13.7.1 WP: 4.8.1 PHP: 7.0.23 (cgi-fcgi, Linux box2002.bluehost.com 3.10.0-614.10.2.lve1.4.50.el6h.x86_64 #1 SMP Mon May 22 17:31:11 EDT 2017 x86_64) MySQL: 5.6.32 WPLANG: en_US Server: Apache safe_mode: 0 max_execution_time: 900 memory_limit: 256M (used: 22.3M | 24M) multisite: N openssl: OpenSSL 1.0.1e-fips 11 Feb 2013 mcrypt: Y LANG: ZipArchive::addFile: Y
0000.149 () Free space on disk containing Updraft’s temporary directory: 1422559.3 MB
0000.149 () Restore job started. Entities to restore: others, db. Restore options: {“updraft_restorer_replacesiteurl”:true,”updraft_encryptionphrase”:””,”updraft_restorer_wpcore_includewpconfig”:false}
0000.166 () Entity: db
0000.166 () restore_backup(backup_file=backup_2017-08-27-1316_Elect_Michael_Shepard_for_Port_C_3b66b396cf48-db.gz, type=db, info=a:0:{}, last_one=)
0000.166 () Unpacking backup… (backup_2017-08-27-1316_Elect_Michael_Shepard_for_Port_C_3b66b396cf48-db.gz, 0.8 Mb)
0000.169 () Database successfully unpacked
0000.170 () Restoring the database (on a large site this can take a long time – if it times out (which can happen if your web hosting company has configured your hosting to limit resources) then you should use a different method, such as phpMyAdmin)…
0000.170 () Using direct MySQL access; value of use_mysqli is: 1
0000.185 () Tried to raise max_allowed_packet from 16 MB to 32 MB, but failed (Access denied; you need (at least one of) the SUPER privilege(s) for this operation, b:0;)
0000.186 () Max packet size: 16 MB
0000.186 () Entering maintenance mode
0000.186 () Enabling Maintenance mode…
0000.186 () Backup of: https://www.shepard4port.com
0000.199 () Content URL: https://www.shepard4port.com/wp-content
0000.199 () Uploads URL: https://www.shepard4port.com/wp-content/uploads
0000.199 () Old table prefix: qftgj_
0000.199 () Site information: multisite=0
0000.200 () New table prefix: 47f_
0000.203 () Processing table (InnoDB): qftgj_options – will restore as: 47f_options
0000.288 () Restoring prior UD configuration (table: 47f_options; keys: 89)
0000.565 () Table prefix has changed: changing options table field(s) accordingly (options)
0000.567 () Options table fields changed OK
0000.571 () Search and replacing table: 47f_options: rows: 504
0000.719 () Processing table (InnoDB): qftgj_users – will restore as: 47f_users