Re: mysql upgrade 5.1.73 to 5.5.46

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