navicat 备份数据库,还原备份有时缺失部分数据
命令:
//查看当前max_allowed_packet的大小
show global variables like 'max_allowed_packet';
//修改max_allowed_packet的大小
set global max_allowed_packet=1024*1024*50;
navicat 备份数据库,还原备份有时缺失部分数据
命令:
//查看当前max_allowed_packet的大小
show global variables like 'max_allowed_packet';
//修改max_allowed_packet的大小
set global max_allowed_packet=1024*1024*50;