MySQL, importing from file, #2006 error, phpmyadmin blank
Posted: 16. February 2010 09:31
I was copying one of my Drupal websites. I exported the database into an sql file. I then began the import into a new empty database. I got an error like this, I didn't write it down perfectly:
After that error phpMyAdmin stopped working and just came up as a blank white page. But other websites using databases on the server were still running ok. I tried restarting mysql but phpmyadmin still didn't work. I finally had to restart my machine and it started working again.
I exported the database again into an sql file and got the same error and phpmyadmin problems trying to import it.
I just uploaded the database with a different sql file I had made earlier without any trouble.
Could this be a problem or bug in mysql or phpmyadmin? Or is the Drupal database I was using have some kind of problem? It seems to be running the site ok.
Any input will be appreciated.
- Code: Select all
INSERT INTO 'cashe_menu' ('cid', 'data', 'espire', 'created', 'header', 'serialized', links:navigation:tree data:a [a bunch of numbers]
MySQL said:
#2006 - MySQL server has gone away
After that error phpMyAdmin stopped working and just came up as a blank white page. But other websites using databases on the server were still running ok. I tried restarting mysql but phpmyadmin still didn't work. I finally had to restart my machine and it started working again.
I exported the database again into an sql file and got the same error and phpmyadmin problems trying to import it.
I just uploaded the database with a different sql file I had made earlier without any trouble.
Could this be a problem or bug in mysql or phpmyadmin? Or is the Drupal database I was using have some kind of problem? It seems to be running the site ok.
Any input will be appreciated.