MySQL Red hat linux

Upgrade MySQL to Version 5.6 in CentOS

Backup all the database and stop mysql

 mysqldump -u (userid) -p (password) --all-databases > all-databases.sql
service mysqld stop

Download the Repo for MySql 5.6


Install the repository from the local file

yum localinstall mysql-community-release-el6-3.noarch.rpm

Install the latest MySql

yum install mysql-community-server
service mysqld start

Configure MySQL to start automatically on Server Reboot

chkconfig mysqld on
chkconfig —list mysqld

Need to apply some tweaks
Its not like the previous versions that tweaks are not required. From Version 5.6 onwards few tweaks are required to make it work fine.

Edit my.cnf file.

vi /etc/my.cnf

Make this changes

innodb_buffer_pool_size=2G  (Allot 50-80% of RAM)

# Default to UTF-8 for text columns

timezone=GMT (This one is optional)

If few attributes are not there in the file then paste it.

Restart MySQL / Apache Service

service mysqld restart
service httpd restart

Leave a Reply

Your email address will not be published. Required fields are marked *