Mysql 5.6: Difference between revisions

From VoIPmonitor.org
Jump to navigation Jump to search
No edit summary
No edit summary
Line 3: Line 3:


  cd /usr/src
  cd /usr/src
  wget http://www.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.19-debian6.0-x86_64.deb/from/http://cdn.mysql.com/ -O mysql-5.6.19-debian6.0-x86_64.deb
  wget http://www.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.20-debian6.0-x86_64.deb/from/http://cdn.mysql.com/ -O mysql-5.6.20-debian6.0-x86_64.deb
  dpkg -i mysql-5.6.19-debian6.0-x86_64.deb
  dpkg -i mysql-5.6.20-debian6.0-x86_64.deb
  rm mysql-5.6.19-debian6.0-x86_64.deb
  rm mysql-5.6.20-debian6.0-x86_64.deb
  mv /etc/mysql/my.cnf /etc/my.cnf
  mv /etc/mysql/my.cnf /etc/my.cnf
  cp /opt/mysql/server-5.6/support-files/mysql.server /etc/init.d/mysql.server && update-rc.d mysql.server defaults
  cp /opt/mysql/server-5.6/support-files/mysql.server /etc/init.d/mysql.server && update-rc.d mysql.server defaults
Line 27: Line 27:
  yum remove mysql-server yum remove mysql
  yum remove mysql-server yum remove mysql
   
   
  wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-shared-compat-5.6.19-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
  wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-shared-compat-5.6.20-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
  wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-shared-5.6.19-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
  wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-shared-5.6.20-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
  wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-client-5.6.19-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
  wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-client-5.6.20-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
  wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-server-5.6.19-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
  wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-server-5.6.20-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
   
   
  rpm -ihv MySQL-shared-compat-5.6.19-1.el6.x86_64.rpm
  rpm -ihv MySQL-shared-compat-5.6.20-1.el6.x86_64.rpm
  rpm -ihv MySQL-shared-5.6.19-1.el6.x86_64.rpm
  rpm -ihv MySQL-shared-5.6.20-1.el6.x86_64.rpm
  rpm -ihv --force MySQL-server-5.6.14-1.el6.x86_64.rpm  
  rpm -ihv --force MySQL-server-5.6.14-1.el6.x86_64.rpm  
  rpm -ihv --force MySQL-client-5.6.14-1.el6.x86_64.rpm
  rpm -ihv --force MySQL-client-5.6.14-1.el6.x86_64.rpm

Revision as of 15:09, 7 August 2014

Debian

cd /usr/src
wget http://www.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.20-debian6.0-x86_64.deb/from/http://cdn.mysql.com/ -O mysql-5.6.20-debian6.0-x86_64.deb
dpkg -i mysql-5.6.20-debian6.0-x86_64.deb
rm mysql-5.6.20-debian6.0-x86_64.deb
mv /etc/mysql/my.cnf /etc/my.cnf
cp /opt/mysql/server-5.6/support-files/mysql.server /etc/init.d/mysql.server && update-rc.d mysql.server defaults
apt-get install libaio1
chown -R mysql /opt/mysql/server-5.6/
chgrp -R mysql /opt/mysql/server-5.6/

upgrade mysql

/opt/mysql/server-5.6/scripts/mysql_install_db --user=mysql --datadir=/var/lib/mysql
rm /opt/mysql/server-5.6/my.cnf 
vi /etc/my.cnf
basedir = /opt/mysql/server-5.6
lc-messages-dir = /opt/mysql/server-5.6/share
remove language = …

Centos

yum install libaio perl
yum remove mysql-server yum remove mysql

wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-shared-compat-5.6.20-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-shared-5.6.20-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-client-5.6.20-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-server-5.6.20-1.el6.x86_64.rpm/from/http://cdn.mysql.com/

rpm -ihv MySQL-shared-compat-5.6.20-1.el6.x86_64.rpm
rpm -ihv MySQL-shared-5.6.20-1.el6.x86_64.rpm
rpm -ihv --force MySQL-server-5.6.14-1.el6.x86_64.rpm 
rpm -ihv --force MySQL-client-5.6.14-1.el6.x86_64.rpm


/etc/init.d/mysql restart
mysql_upgrade