MySQL server has gone away

[Sam KriegParticipant]

Trying to restore the live site DB on staging, which has worked before.

Now it gets stuck at

Processing table (InnoDB): wp_postmeta - will restore as: 7u_postmeta
tage":"db","data":{"stage":"table","table":"wp_XXXXXX_postmeta"}}"db","data":{"stage":"table","table":"wp_postmeta"}}Database queries processed: 1000 in 305.25 seconds
"table":"wp_postmeta"}}:{"stage":"table","table":"wp_postmeta"}}e","stage":"db","data":{"stage":"table","table":"wp_postmeta"}}Database queries processed: 1250 in 400.41 seconds
able","table":"wp_postmeta"}}

and from there on it gets odd. Activity log jumps “x Cleaning” goes to “Finished”, when I try to see the log I end up at the “wp maintenance screen”, going back to the WP Admin there’s a “Unfinished restoration” alert and clicking on “Continue restoration” finally presents me the MySQL server has gone away.

Any ideas what to do?

some screenshots…
https://snipboard.io/EFdc02.jpg
https://snipboard.io/EFdc02.jpg
https://snipboard.io/hRB2ql.jpg
https://snipboard.io/09H1ai.jpg
https://snipboard.io/BI1P70.jpg
https://snipboard.io/uoQntR.jpg

• This topic was modified 4 months ago by Sam Krieg.

[udadminKeymaster]

Your post contains a link that contains a link with wp-admin in it, linking to a WordPress admin dashboard. Such links can only be accessed by someone who is logged into WordPress. If you are wanting us to visit your WordPress admin dashboard, then please make a private reply with the necessary credentials (do not post them in a public post). Otherwise, please post again to confirm that no credentials are needed for us to visit the link.

[Sam KriegParticipant]

This reply has been marked as moderator-only.

[VanessaModerator]

Hi Sam,

Without your log this is just a guess. It looks to me like the restoration is timing out on the post meta table.
It would be worth optimising your DB with our free plugin WordPress-Optimize (getwpo.com). This is often enough to get the restoration through.

[Author]

Posts