Help with MySQL dying during a script install
I have a 512MB droplet, yes the cheapest one, for playing with different projects. I am trying to install a web script called PHPMyFAQ (http://www.phpmyfaq.de/).
The server meets all the requirements as far as software versions but I can’t get it to install. I’ve tried 3 versions of the program to make sure it wasn’t just a bad version. I updated PHP on the droplet to test as well.
What happens is , at some part of the script install, it is setting up the database but then dies. I do get this as part of the error:
“Error while fetching result: MySQL server has gone awayError while fetching result: MySQL server has gone awayError while fetching result: MySQL server has gone away”
The installer doesn’t finish, nor does the program work.
I have a swap file of 1GB and not sure if this is a memory out kind of error.
I don’t know why this script would be causing MySQL to crash. I’ve installed other large scripts before without any problem, like Prestacart and Opencart for example.
I don’t know why I’m missing at this point or how to troubleshoot why the droplet can’t handle it. Why MySQL dies.
When I run “status” on mysql, it tells me the uptime is 208 days, 20 hours etc. It doesn’t act like it has crashed at all. So why would “MySQL has gone away” mean if it’s not crashing?
I’m just a bit confused, not sure if this is a server issue, MySQL issue, or just this script. And note that I have installed the script just fine on a local WAMP setup.
What can I do to make sure it’s not my server that is just maxing out somehow?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.