MAMP-#2006-MySQL服务器不见了 [英] MAMP - #2006 - MySQL server has gone away

问题描述

我正在尝试使用MAMP导入8MB的数据库(我无法使其更小)，并且不断出现以下错误.

Im trying to import a database thats 8MB (i cant make it smaller) with MAMP and I keep getting the error below.

我已经读到我需要更改我的max_allowed_pa​​cket，但是我想我已经做到了，但这仍然行不通.有没有办法找出max_allowed_pa​​cket(以及其他相关设置)的设置?

Ive read that I need to change my max_allowed_packet but I think ive done this and it still doesn't work. Is there a way I can find out what the max_allowed_packet (and any other relevant settings) are set to?

或者有人可以尝试其他解决方案吗?谢谢

Or does anyone have any other solutions to try? Thanks

错误 SQL查询:

插入cache_menu(cid，data，expire，created，serialized)值('links:management:tree-data:en:ec99d3452fef1ede622e66c68ba908b1dad455aa71f5e68648aeec6488b89c88'，[...]

INSERT INTO cache_menu (cid, data, expire, created, serialized) VALUES ('links:management:tree-data:en:ec99d3452fef1ede622e66c68ba908b1dad455aa71f5e68648aeec6488b89c88', 0x613a323a7b733a343a2274726565223b613a313a7b693a313b613a323a7b733a343a226c696e6b223b613a34323a7b733a393a226d656e755f6e616d65223b733a31303a226d616e6167656d656e74223b733a343a226d6c6964223b733a313a2231223b733a343a22706c6964223b733a313a2230223b733a393a226c696e6b5f70617468223b733a353a2261646d696e223b733a31313a22726f757465725f70617468223b733a353a2261646d696e223b733a31303a226c696e6b5f7469746c65223b733a31343a2241646d696e697374726174696f6e223b733a373a226f7074696f6e73223b733a363a22613a303a7b7d223b733a363a226d6f64756c65223b733a363a2273797374656d223b733a363a2268696464656e223b733a313a2230223b733a383a2265787465726e616c223b733a313a2230223b733a31323a226861735f6368696c6472656e223b733a313a2231223b733a383a22657870616e646564223b733a313a2230223b733a363a22776569676874223b733a313a2239223b733a353a226465707468223b733a313a2231223b7[...]

MySQL说:

推荐答案

将my-large.cnf复制到MAMP/Library，并将其重命名为my.cnf(然后重新启动MAMP)已解决了此问题.

Copying my-large.cnf to MAMP/Library and renaming it to my.cnf (and restarting MAMP) fixed this.

这篇关于MAMP-#2006-MySQL服务器不见了的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！