Mysql 5.6

From VoIPmonitor.org
Jump to navigation Jump to search

Debian 7

apt-get install libaio1
wget "http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-server_5.6.22-1debian7_amd64.deb-bundle.tar"
tar xf mysql-server_5.6*-1debian7_amd64.deb-bundle.tar 
dpkg -i mysql-*.deb

Debian 6

cd /usr/src
wget http://www.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.22-debian6.0-x86_64.deb/from/http://cdn.mysql.com/ -O mysql-5.6.22-debian6.0-x86_64.deb
dpkg -i mysql-5.6.22-debian6.0-x86_64.deb
rm mysql-5.6.22-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 7,6,5 by YUM repos

FRESH install (removes/backups previous data)

Stop voipmonitor service

/etc/init.d/voipmonitor stop

Copy link to mysql-community-repository for RH7,RH6 or RH5 from here (if you have centos 6.6 download for RH6)

http://dev.mysql.com/downloads/repo/yum/

and download and install:

mkdir /usr/src/mysql
cd /usr/src/mysql
wget http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
yum localinstall http://dev.mysql.com/downloads/repo/yum

Backup previous data of mysql:

service mysqld stop
mv /var/lib/mysql /var/lib/mysql-old

Create new system tables and database for mysql

mysql_create_database

Start mysql and setup root password (remove anonymous user and test db)

service mysqld start
mysql_secure_installation

Start voipmonitor service (this will create tables neeeded by service in mysql)

/etc/init.d/voipmonitor start

After startup of a service please login to GUI and setup root password/users.

Centos 5

Remove old mysql server and install packages needed for upgrade

yum install libaio perl
yum remove mysql-server mysql

Install mysql-community repository

wget http://dev.mysql.com/get/mysql-community-release-el5-5.noarch.rpm
rpm -Uvh mysql-community-release-el5-5.noarch.rpm

Check for successfully added repository and install new mysql-server

yum repolist enabled | grep "mysql.*-community.*"
yum install mysql-community-server

Recreating/upgrading tables engine, first manualy run mysql-server and after successfully upgrade set ownership of /var/lib/mysql back to mysql

mysqld_safe --skip-grant-tables --skip-secure-auth --skip-networking
mysql_upgrade -p
chmod -R mysql:mysql /var/lib/mysql

Mysql start/check/stop service

service mysqld start
service mysqld status
service mysqld stop

how to yum ref: http://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/linux-installation-yum-repo.html