On Thu, Oct 22, 2015 at 6:50 PM, Ajeesh Kannan <ajeeshbkan...@gmail.com> wrote:
> > > On Thu, Oct 22, 2015 at 4:40 PM, P.R.Karthik <prk...@gmail.com> wrote: > >> Hi, >> >> 1) Shutdown the MySQL and have a backup of data directory. >> 2) Replace the MySQL binary files. >> 3) start the MySQL server with the old data directory. >> 4) Run the mysql_upgrade to fix the internal tables. >> >> Go with mysql 5.1 to MySQL 5.5. Then move on to MySQL 5.6. MySQL 5.7 will >> be GA by next week. >> >> Consider using Percona Server if there is a heavy need and client accepts. >> You can also try MariaDB 5.5 if you need more benefit from the Optimizer. >> >> Regards, >> KarthiK.P.R >> >> On Wed, Oct 21, 2015 at 12:43 PM, Arun Khan <knu...@gmail.com> wrote: >> >> > On Tue, Oct 20, 2015 at 11:26 PM, Ajeesh Kannan < >> ajeeshbkan...@gmail.com> >> > wrote: >> > > Hi, >> > > >> > > Is there any good document to refer mysql server upgrade from 5.1.73 >> to >> > > mysql 5.5.46. >> > > >> > >> > Don't know about docs but take *backup* of your data before attempting >> > the upgrade! >> > >> > Off the cuff - why stop at 5.5.46? GA 5.6.x is also available from >> > Percona's site and 5.7, with performance improvement (claimed by >> > Oracle), is set to be released in a month or so. >> > >> > IIRC, MySQL site has release notes and/or docs for upgrades. I would >> > suggest you do the migration in smaller steps i.e. 5.1 to 5.2 and so >> > forth. >> > >> > -- Arun Khan >> > _______________________________________________ >> > ILUGC Mailing List: >> > http://www.ae.iitm.ac.in/mailman/listinfo/ilugc >> > ILUGC Mailing List Guidelines: >> > http://ilugc.in/mailinglist-guidelines >> > >> _______________________________________________ >> ILUGC Mailing List: >> http://www.ae.iitm.ac.in/mailman/listinfo/ilugc >> ILUGC Mailing List Guidelines: >> http://ilugc.in/mailinglist-guidelines >> > > > Thank you Karthik, > > My serve is using the following bin files. > > ]# rpm -qa | grep mysql > mysql-5.1.73-3.el6_5.x86_64 > mysql-libs-5.1.73-3.el6_5.x86_64 > mysql-server-5.1.73-3.el6_5.x86_64 > mysql-devel-5.1.73-3.el6_5.x86_64 > > So I need to replace all these bin files with matching 5.5 binary file ? > > Or i would need to replace each and every files. ~]$ rpm -ql mysql-5.1.73-3.el6_5.x86_64 /usr/bin/msql2mysql /usr/bin/my_print_defaults /usr/bin/mysql /usr/bin/mysql_config /usr/bin/mysql_find_rows /usr/bin/mysql_waitpid /usr/bin/mysqlaccess /usr/bin/mysqladmin /usr/bin/mysqlbinlog /usr/bin/mysqlcheck /usr/bin/mysqldump -- With Regards, Ajeesh B.Kannan _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc ILUGC Mailing List Guidelines: http://ilugc.in/mailinglist-guidelines