Contacto +52(442)298-0967 msn@swideascom

MySQL adventures – Upgrading from MySQL 5.4 to 5.6

MySQL adventures – Upgrading from MySQL 5.4 to 5.6

4a5e46aca034277d3fee8985a6170c55[1]Arch: Centos 5 | Linux 2.6.18-028stab107.1 #1 SMP Wed Apr 17 19:10:55 MSD 2013 i686 i686 i386 GNU/Linux

[dropcap]T[/dropcap]he background. After being updating some services at our server (GoDaddy VPS deluxe plan), we came with the great idea (at least it looked like) of upgrade from MySQL 5.4 to 5.6, so through WHM and after a few minutes of watching few warning and failures in the upgrade log console, the system failed at the end of upgrade, mysql service was down and restarting the server didn’t fix anything, so the last resource (before calling support team like a sissy girl) was go inside SSH console and speak to the server through there.

The Problem

Using Putty (or any ssh client), you should go and first try to restar/start you MySQL service/agent using the next command:

And going a little more deep you could try to restar/start the mysqld (MySQL Server, not the service)

The Solution

Ok, now we’re getting something more specific,  so the PID file isn’t working as it should,  first search for this PID file inside etc/ folder,  then we’re gonna need to use this:

That should solve the PID file problem, so now we try to restart MySQL Server

Ta-da!

adventure-time-science

CEO SWFideas pro·gram·mer (n) An organism capable of converting caffeine into code. *RichMedia Developer | *Homodevelopus

0 Comments

Leave a reply