Upgrade MySQL 5.5.16

Abhishek Rukhaiyar:

Problem Solver for me.

Originally posted on Mani's Blog:

Overview

We upgraded our environment to Enterprise Edition.  Upgrading MySQL process pretty much simple process.   However there are some know issues, even there is bug in upgrading performance schema.

  1. Download binaries from http://www.oracle.com
    MySQL-*-5.5.16*
  2. copy them to local Filesystems.
    cd /usr/local/src
    cp /local/mysql/backups/MySQL_Software/5.5.16_ent/* .
  3. Stop the mysql
    /etc/init.d/mysql stop
  4. Make sure mysql is not running
    ps -ef |grep mysqld |grep -v grep
  5. Uninstall existing MySQL binaries
    forx in `rpm -qa |grep MySQL |grep "5.5"`;
    do
    echo "rpm -e ${x}";
    done
  6. Install new 5.5.16 binaries
    rpm -ivh --force --nodeps MySQL-client-advanced-5.5.16-1.rhel5.x86_64.rpm
    rpm -ivh --force --nodeps MySQL-shared-advanced-5.5.16-1.rhel5.x86_64.rpm
    rpm -ivh --force --nodeps MySQL-devel-advanced-5.5.16-1.rhel5.x86_64.rpm
    rpm -ivh --force --nodeps MySQL-server-advanced-5.5.16-1.rhel5.x86_64.rpm
  7. Start Mysql
    /etc/init.d/mysql start
  8. Run mysql_upgrade
    mysql_upgrade --skip-write-binlog -uroot -p
  9. Stop the mysql

View original 552 more words

About these ads
Categories: Uncategorized

21 Pictures That Will Restore Your Faith In Humanity

Excellent collection. Humanity is always there and it will always be there. These photos are just few examples out of millions moments without any snaps.

Categories: Uncategorized

How to Prepare for JEE 2013 After Appearing for 12th Board:Part 1

Prepare for JEE 2013

Prepare for JEE 2013: Time to Work Harder

The restructuring of AIEEE and IIT JEE in 2013 is creating a lot of confusion among the minds of aspirants. It is very important to clear all the confusion. Read my article What is JEE 2013 to clear all your doubts.

Prepare for JEE 2013: Introduction

You should know that to prepare for JEE 2013, the time after 12th board is very precious. It should be utilized in the optimal way to get the best result. The time period is very short and its optimal utilization will guarantee the best rank that you are capable to achieve by giving your best shot. And, you have to give your best shot.

This time period of almost 70 days is going to decide your career’s fate. You will be among elite group of the society or average. All will depend on your performance in these 70 days. Hence, it is very important to take a systematic approach to maximize the chance of giving your best performance.

Prepare for JEE 2013: For Whom

I’m writing this article for those aspirants of JEE 2013 who are appearing for 12th board and afterwards planning to appear for both JEE (Main) and JEE (Advanced). This article will not address preparation for paper 2 of JEE (Main) or aptitude test of JEE (Advanced). It will be published in two parts; first part will be about preparation for JEE (Main). Second part will address JEE (Advanced) preparation. Keep almost 15-20 different sets of simulator tests for both JEE (Main) and JEE (Advanced). However, before going in detail please go through my article, Most Suitable date for JEE (Main) Online Test.

Prepare for JEE 2013: First Learn Concepts

Some years ago, I had written an article, How to prepare for IIT JEE. The article described three step for IIT JEE preparation. Even though a lot has changed since then in the format of JEE, still…….. Read the Complete article

Categories: Education
Follow

Get every new post delivered to your Inbox.

Join 85 other followers