Navicate for mysql Data Transmission Problems

Navicate for mysql Data Transmission Problem 1. MySQL server has gone away With statement solution:

Mysql> set global wait_timeout = 2880000; mysql> set global interactive_timeout = 2880000; mysql> set global max_allowed_packet = 100*1024*1024;

 

Set the three values (set them in the mysql Command Prompt line client, as shown below ). 2. The system prompts that the foreign key cannot be transmitted or deleted. Solution:

Mysql> set global FOREIGN_KEY_CHECKS = 0;

 

Cancels the constraint. After the transfer is complete, you can set 0 to 1 (if constraints are required)

Mysql> set global FOREIGN_KEY_CHECKS = 1;