Greetings, the previous posts/answers about this issue have not helped me resolve the issues I am having.

I am moving a site from one old host to a new host.

I have moved the files from the old host and uploaded to the new account on the new host. I have recreated a new database and I am trying to use PHPMYADMIN to import the SQL database file which I exported from old host.

THe error I am getting is:

Error
SQL query:

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

MySQL said: #2006 - MySQL server has gone away

I'd really appreciate your assistance…. I just want to be able to use my new server…

Question, can I simply empty that table on old host and export again?

Or do I can I do something at the import stage on the new server to ignore this part of the import.

I thank you all in advance for any assistance .

cheers
James

Comments

Alperian’s picture

I had to show a client a local imported copy on WAMP and I had to remove the cache_menu table from the import in order to get it to work after a fashion.

if I empty the table on the working live, but not exportable, site, will I start to get "could not create file" warnings?

fchometon’s picture

I had the same problem to migrate a site from an old to a new hosting.
The cache_menu table would not migrate.
I cleared the table, the data were recreated when I relaunched the site on the new hosting.
I had no problem to clear the table.

sashkernel’s picture

In my case I did not have original site, but I had exported db into mysite.sql

I removed anything in

--
-- Dumping data for table `cache_menu`
--

and it worked.

aniket.mohite88’s picture

Thanks sashkernel for the answer.
This really worked. I had taken db exports for a few sites & forgot to clear the cache before taking the export.

It has been suggested many times to clear cache before exporting the data. Your trick helps.

ankitgarg’s picture

Works for me. Thanks :)

Ankit Garg

rwenzke’s picture

This happens every time I export my db from mamp. Is there a better way than clearing the table each time?

anuj_123’s picture

Thanx sashkernel for your response