This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

[TUTORIAL] Upgrading mysql 5.1 to 5.4 + phpmyadmin CENTOS 6.4
#1
[TUTORIAL] Upgrading mysql 5.1 to 5.4 + phpmyadmin CENTOS 6.4
Hi, after 10 times rebuilding my VPS with CentOS 6/7 I finally get my upgrade.

System: CentOs 6.4
Sentora: Beta 1.0.0
Mysql: 5.1 (from sentora)
Phpmyadmin (from sentora)

Now follow the steps:

cd /etc/yum.repos.d
wget http://rpms.famillecollet.com/enterprise/remi.repo
yum --enablerepo=remi update mysql-server
mysql_update -u root -p

Congratulations, your mysql has been upgraded.

cd /etc/zpanel/panel/etc/apps
mv phpmyadmin phpmyadmin_old
mkdir phpmyadmin

Now download the phpmyadmin 4.1.7 (or your choice) to your desktop
Login into WinSCP and access /etc/zpanel/panel/etc/apps/phpmyadmin then upload all files
Copy the config.inc file from phpmyadmin_old to phpmyadmin folder and delete the old folder.

Congratulations, your phpmyadmin has been upgraded.
Reply
Thanks given by:
#2
RE: [TUTORIAL] Upgrading mysql 5.1 to 5.4 + phpmyadmin CENTOS 6.4
I have a better solution. I am using MariaDB latest version with TokuDB and getting better performance than mysql. I will sugggest you to use MariaDB. Smile
Reply
Thanks given by:
#3
RE: [TUTORIAL] Upgrading mysql 5.1 to 5.4 + phpmyadmin CENTOS 6.4
TokuDB does not support foreign keys and is not compatible 100% with innoDB. So it's quitly different here as a choice.

Would be an issue for a lot of CMS. Also tokuDB require at least 50% of ram for cache ( in GB if available).

Require mySQL 5.5 ( not available in centos 6.x branch!)

http://www.slideshare.net/tmcallaghan/ge...ith-tokudb

http://unix.stackexchange.com/questions/...-to-tokudb

http://www.percona.com/blog/2013/05/07/b...vs-innodb/

Also for MySQL updrade beware using REMI repos will cause a lot of dependencies conflict that would be hard to resolve!

M B
No support using PM (Auto adding to IGNORE list!), use the forum. 
How to ask
Freelance AWS Certified Architect & SysOps// DevOps

10$ free to start your VPS
Reply
Thanks given by:
#4
RE: [TUTORIAL] Upgrading mysql 5.1 to 5.4 + phpmyadmin CENTOS 6.4
(01-24-2015, 08:21 PM)Me.B Wrote: TokuDB does not support foreign keys and is not compatible 100% with innoDB. So it's quitly different here as a choice.

Would be an issue for a lot of CMS. Also tokuDB require at least 50% of ram for cache ( in GB if available).

Require mySQL 5.5 ( not available in centos 6.x branch!)

http://www.slideshare.net/tmcallaghan/ge...ith-tokudb

http://unix.stackexchange.com/questions/...-to-tokudb

http://www.percona.com/blog/2013/05/07/b...vs-innodb/

Also for MySQL updrade beware using REMI repos will cause a lot of dependencies conflict that would be hard to resolve!

M B

Yah, I know that. But I am using Wordpress on my server and I am really happy with it. But 50% usage really a bad issue I am feeling. Smile Let's see how can I develop it.
Reply
Thanks given by:


Possibly Related Threads…
Thread Author Replies Views Last Post
How to upgrade php and mysql version? davidlambda 4 28 ,531 03-11-2020, 06:16 PM
Last Post: davidlambda
How to install older sentora with older mysql version atomiq 0 4 ,453 11-30-2019, 04:27 PM
Last Post: atomiq
How to update mySQL to version 5.6? jeremyotten 21 73 ,971 12-15-2016, 11:19 PM
Last Post: claudiobiato

Forum Jump:


Users browsing this thread: 1 Guest(s)