How To Upgrade MySQL from 5.5 to 5.7 on CentOS/AWS Linux

Author: , December 7th, 2017

START: Server version: 5.5.54-log MySQL Community Server (GPL) FINISH: Server version: 5.7.20-log MySQL Community Server (GPL) 1 2 3 4 5 6 mysql –execute="SET GLOBAL innodb_fast_shutdown=0;" service mysqld stop yum remove mysql mysql-* yum install mysql57-devel mysql57-server mysql57-test service mysqld start mysql_upgrade mysql –execute=”SET GLOBAL innodb_fast_shutdown=0;” service mysqld stop yum remove mysql mysql-* yum install […]

How To Fix yum after Python Upgrade

Author: , December 8th, 2015

I upgraded to Python 2.7 and yum promptly broke. The quick fix is to edit the yum executable script and change the top line that invokes Python: sudo vim `which yum` CHANGE FROM: #!/usr/bin/python TO: #!/usr/bin/python26 UPDATED August 2nd, 2016: On one system, I had to use the following Python 2.4 fix instead, even though […]

How To Fix MySQL Error “Cannot load from mysql.proc. The table is probably corrupted”

Author: , July 22nd, 2013

Do a full backup first, just in case! mysql_upgrade -u root -p

Amazon Linux Upgrade Woes

Author: , April 10th, 2012

Upgraded the OS on one of my Amazon server instances today. After rebooting I had the unpleasant experience of seeing my rpc.rstatd monitoring daemon stop functioning. It turns out that AWS changed the actual kernel version for this release, I guess to “celebrate” the fact that it is no longer “beta”. The difficulty is that […]

How To Fix Broken Boot After Yum Update On Amazon Linux

Author: , January 20th, 2012

Stop the instance first…YMMV: 1 2 3 4 5 yourHost# ec2-describe-images describe-images -o amazon –filter "manifest-location=*pv-grub-hd0_1.02-i386*" –region us-east-1 IMAGE   aki-805ea7e9    ec2-public-images/pv-grub-hd0_1.02-i386.gz.manifest.xml amazon  available   public      i386    kernel              instance-store  paravirtual xen   yourHost# ec2-modify-instance-attribute –kernel aki-805ea7e9 –region us-east-1 i-39764XXX kernel  i-39764XXX  aki-805ea7e9 yourHost# ec2-describe-images describe-images […]

How To Upgrade PHP to PHP53 On CentOS

Author: , August 22nd, 2011

1 2 3 4 # service httpd stop # yum erase php-common php # yum install php53* # service httpd start # service httpd stop # yum erase php-common php # yum install php53* # service httpd start To get mcrypt installed, read this post:

Rock On

Author: , January 25th, 2011

Worked like a madman yesterday to be ready for launch at midnight. At 10pm, the launch was scrubbed and reset back 24 hours. Whew! This is a wild project. Hopefully we can get everything under control today and launch tonight. That would ease the pressure on everyone considerably. Crashed by 10:30, and been up since […]

How To: Upgraded to Parallels 5, Got BSOD IRQL_NOT_LESS_OR_EQUAL

Author: , November 18th, 2009

After upgrade from Parallels Desktop version 4 to version 5 Windows XP virtual machine fails to boot. IRQL_NOT_LESS_OR_EQUAL Blue Screen of Death is displayed. Reason: The IRQL_NOT_LESS_OR_EQUAL BSOD (Blue Screen of Death) happens due to multiple CPUs assigned to the virtual machine. The Fix: Decrease the amount of CPUs to 1: After Parallels Tools are […]