On Thu, Oct 22, 2015 at 4:40 PM, P.R.Karthik <prkart at 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 <knura9 at gmail.com> wrote:
On Tue, Oct 20, 2015 at 11:26 PM, Ajeesh Kannan <ajeeshbkannan at 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