Author Topic: MySQL 5.6.46  (Read 1441 times)

Paul Smedley

  • Sr. Member
  • ****
  • Thank You
  • -Given: 12
  • -Receive: 54
  • Posts: 474
    • View Profile
MySQL 5.6.46
« on: October 26, 2019, 10:13:22 am »
Hi All,

based on my patches to MySQL 5.5, I updated the source to 5.6.46 and OS/2 binaries are available from http://smedley.id.au/tmp/mysql-5.6.46-os2-20191026.zip

This is very lightly tested, but so far at least, appears to work OK.

Not sure how many people are still running MySQL on OS/2?

Cheers,

Paul

Joop

  • Sr. Member
  • ****
  • Thank You
  • -Given: 0
  • -Receive: 44
  • Posts: 487
    • View Profile
Re: MySQL 5.6.46
« Reply #1 on: October 26, 2019, 08:39:12 pm »
Thanks Paul, still busy figuring out how to set up and converting existing databases or card boxes to sql databases. I seems all not that easy. When I have a sql database I can go figuring out how to connect with Java programs, there are some programs which do run very well with our version of OpenJDK.

Joop

  • Sr. Member
  • ****
  • Thank You
  • -Given: 0
  • -Receive: 44
  • Posts: 487
    • View Profile
Re: MySQL 5.6.46
« Reply #2 on: October 26, 2019, 09:15:29 pm »
In the readme "For new users, to create the initial databases, unzip mysql_sample_database.zip in the mysql51 directory which will create a 'data' directory". This is from an older distribution and can not be found in the new.
An other thing which puzzles me is the size;
mysql-5.1.72-os2-20130925.zip - 26.859.072
mysql-5.6.46-os2-20191026.zip - 64.230.836
What happened between those two that it grow more than twice the size? And this is just an zip file.

ivan

  • Hero Member
  • *****
  • Thank You
  • -Given: 2
  • -Receive: 35
  • Posts: 1026
    • View Profile
Re: MySQL 5.6.46
« Reply #3 on: October 26, 2019, 10:26:24 pm »
Hi Joop,

I think you will find the large version is compiled as a debug version.

Paul Smedley

  • Sr. Member
  • ****
  • Thank You
  • -Given: 12
  • -Receive: 54
  • Posts: 474
    • View Profile
Re: MySQL 5.6.46
« Reply #4 on: October 26, 2019, 11:13:17 pm »
In the readme "For new users, to create the initial databases, unzip mysql_sample_database.zip in the mysql51 directory which will create a 'data' directory". This is from an older distribution and can not be found in the new.
An other thing which puzzles me is the size;
mysql-5.1.72-os2-20130925.zip - 26.859.072
mysql-5.6.46-os2-20191026.zip - 64.230.836
What happened between those two that it grow more than twice the size? And this is just an zip file.

Main reason is that in mysql 5.1; we built a DLL that all the client utilities shared. The build system changed in 5.5+ to cmake, and at this point in time, I haven't adapted things to use a DLL. Hence all the client utilities grew a little :)

I also forgot to lxlite the executables (although this probably wouldn't change the zip file size much).

Cheers,

Paul

David McKenna

  • Full Member
  • ***
  • Thank You
  • -Given: 9
  • -Receive: 10
  • Posts: 219
    • View Profile
Re: MySQL 5.6.46
« Reply #5 on: October 27, 2019, 01:21:51 pm »
Hi Paul,

  Been using MySQL 5.1 for a long time (installed originally by AMPOS/2) but never was able to figure out how to update the database past 5.1. Was able to install 5.6 with a newly created database and it seems to work OK - can open it with phpmyadmin and manipulate things as before. Thanks for the update!

Regards,

Paul Smedley

  • Sr. Member
  • ****
  • Thank You
  • -Given: 12
  • -Receive: 54
  • Posts: 474
    • View Profile
Re: MySQL 5.6.46
« Reply #6 on: October 28, 2019, 03:06:23 am »
Hi Dave,

  Been using MySQL 5.1 for a long time (installed originally by AMPOS/2) but never was able to figure out how to update the database past 5.1. Was able to install 5.6 with a newly created database and it seems to work OK - can open it with phpmyadmin and manipulate things as before. Thanks for the update!

You should be able to copy over the data directory from mysql 5.1 to 5.6; then restart mysqld - you'll get a bunch of errors/warnings; but running mysql_upgrade should fix those....

Cheers,

Paul.

David McKenna

  • Full Member
  • ***
  • Thank You
  • -Given: 9
  • -Receive: 10
  • Posts: 219
    • View Profile
Re: MySQL 5.6.46
« Reply #7 on: October 28, 2019, 11:09:45 am »

You should be able to copy over the data directory from mysql 5.1 to 5.6; then restart mysqld - you'll get a bunch of errors/warnings; but running mysql_upgrade should fix those....

Cheers,

Paul.

 Tried that, but ended up with a bunch of errors, and an 'upgrade failed' message. Having read about it some more, I think it needs to be upgraded one version at a time - can't go from 5.1 directly to 5.6, need to do each version in sequence... need to check that.

Regards,

Paul Smedley

  • Sr. Member
  • ****
  • Thank You
  • -Given: 12
  • -Receive: 54
  • Posts: 474
    • View Profile
Re: MySQL 5.6.46
« Reply #8 on: October 28, 2019, 10:02:51 pm »
Hi David,

Tried that, but ended up with a bunch of errors, and an 'upgrade failed' message. Having read about it some more, I think it needs to be upgraded one version at a time - can't go from 5.1 directly to 5.6, need to do each version in sequence... need to check that.

That may be the case - there's a 5.5 port on my site.... I did upgrade 5.1 -> 5.5 -> 5.6

If I remember tonight, I'll try the 5.1 -> 5.6 upgrade and see if I get the same error.

Cheers,

Paul.