Re: mysql upgrade 5.1.73 to 5.5.46
Ajeesh Kannan <[email protected]>
| Newsgroups | gmane.org.user-groups.linux.ilugc |
|---|---|
| Message-ID | <CA+ark-oGLRmcwQA3RGPE-j5iEu9G1CZN+7eFazh+SY2_6kQLDw@mail.gmail.com> |
On Thu, Oct 22, 2015 at 4:40 PM, P.R.Karthik <[email protected]> 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 <[email protected]> wrote: > > > On Tue, Oct 20, 2015 at 11:26 PM, Ajeesh Kannan <[email protected] > > > > 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 ? -- 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