Migration failed – max_packet_allowed

[ChristopherParticipant]

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

[Dee NutbourneModerator]

Hi,

Apologies for the delay.

It appears that the restoration is being timed out or killed off partly through the database restoration. It is possible that there is not enough time allowed by the server to process the users table.

The ‘max_allowed_packet’ message is not a fatal error, and is considered normal. UpdraftPlus attempts to raise this, but will continue regardless.

I would recommend restoring the other sections of the backup separately, then restoring the database backup via phpMyAdmin (or equivalent). You should be able to import the database backup file directly into phpMyAdmin.
I assume that the domain/URL of the site is not changing. If this is the case, then nothing further will need to be done for the database.

Best Wishes,
David N

[Author]

Posts