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
I have exactly this too
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?
^-^
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.
In my case I did not have
In my case I did not have original site, but I had exported db into mysite.sql
I removed anything in
and it worked.
This worked
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.
Works for me. Thanks :)
Works for me. Thanks :)
Ankit Garg
What causes the issue?
This happens every time I export my db from mamp. Is there a better way than clearing the table each time?
thanx
Thanx sashkernel for your response