Database only partly imported
Posted by: Peter Laman
Date: June 01, 2018 08:30AM

In order to debug code on my website I need a fresh copy from the production database. I made a backup of it with cPanel, which gives me an SQL script to regenerate the data.

My dev environment is WAMP and I used the MySQL console utility to execute the script. It executed, but not without errors and in the end only about half of the tables were created and populated. During the process I got this message a few times:

ERROR 2006 (HY000): MySQL server has gone away

I already increased the max packet size:

SET GLOBAL max_allowed_packet=1073741824;

What could cause this and how to solve it?

Options: ReplyQuote


Subject
Written By
Posted
Database only partly imported
June 01, 2018 08:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.