- This topic has 2 replies, 3 voices, and was last updated 4 months ago by Vanessa.
-
Posts
-
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.
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.
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.
- The topic ‘MySQL server has gone away’ is closed to new replies.