MySQL Bugs: #82966: Problems installing MySQL 8 preview on windows

Bug #82966	Problems installing MySQL 8 preview on windows
Submitted:	13 Sep 2016 11:55	Modified:	19 Sep 2016 13:31
Reporter:	Peter Laursen (Basic Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	1.4.17	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
Downloads page http://dev.mysql.com/downloads/mysql/ provides two zip archives for download of MySQL 8 preview.

Funnily I was futher able to download a file "mysql-installer-community-8.0.0.0-dmr.msi" 295 MB in size from same site 30 minutes ago.  Links to that file have now disappeared. It also does not install MySQL 8 preview at all! It may contain the MySQL 8 binaries etc., but manifest is not updated to recognize it. Manifest "upgrade check" from existing installation also does not find any updated manifest.

How to repeat:
See above.

Suggested fix:
Update MySQL Installer manifest to recognize MySQL 8 preview (in both the installer package - if you want to provide such at cutrent stage - and the web used by MySQL Installer "upgrade check".

The.zip can be used of course (by users who know how to) but there will be a lot of upgrades in this tree, and using the Installer for managing upgrades is the most convenient.

The referred "mysql-installer-community-8.0.0.0-dmr.msi" can still be found at http://dev.mysql.com/downloads/file/?id=465601

BTW: Docs at http://dev.mysql.com/doc/refman/8.0/en/windows-installation.html lists both installation options (MySQ Installer and .zip archives) as available.

Hello Peter,

Thank you for the bug report.

Thanks,
Chiranjeevi.

Posted by developer:
 
This seems to have been a problem with the manifest publication / propagation which is fixed now.

Well,the manifest hasn't progagated to me yet, and the Installer package i downloaded 1 hour ago also does not update my current manifest. Itd oes however copy a 8.0 installer ("mysql-8.0.0-dmr-winx64.msi") into the Installer's "product cache"(C:\ProgramData\MySQL\MySQL Installer for Windows\Product Cache) . However this installer does nothing but decompressing and copying files. It does not create datadir, system tables, Windows service etc.

changing status to "open"

Dear Peter, the description of the error you provided mixes several concepts and each one should be treated separatedly. I'll try to explain each one in detail some lines bellow. The Steps you provided to reproduce the error appear confusing (at least to me) and they seem a bit incomplete (see the images in the reference from bellow I just ran the web installer and tested the 'happy day scenario' to install MySQL 8.0). Here are my notes regarding what's noted in the description:

if you downloaded zips from Downloads http://dev.mysql.com/downloads/mysql/

1) Those did not dissapeared and are still there under the Development Releases tab. The links from the buttons point to:
http://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.0-dmr-winx64.zip
http://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.0-dmr-winx64-debug-test.zip
Depending on what version of then you want a copy of.

2) Those are not Installer bundles, those are "no-install zip" files. The bundles when executed copy some files to your system and execute others, and for every installed product they generate the required registry entries. The second ones mentioned (no-install zips) can be extracted to any place you like in the system and do not generate any registry changes nor windows services (though you can create those manually however, after the contents of the zips where extracted).

Now, about the msi (bundled) installers:
1) The file you mentioned 'mysql-installer-community-8.0.0.0-dmr.msi' is available for download from: http://dev.mysql.com/downloads/installer/ on a similar fashion under the Development Releases tab. Its links are:
http://dev.mysql.com/get/Downloads/MySQLInstaller/mysql-installer-community-8.0.0.0-dmr.ms...
http://dev.mysql.com/get/Downloads/MySQLInstaller/mysql-installer-web-community-8.0.0.0-dm...
Since the full bundle is 295.8 Mb If you're on a hurry I suggest you to download the web installer (1.6Mb). The Full bundle is mostly encouraged for offline installations.

2) Since the Server 8.0.0 is a PREVIEW and not a GA'd product, you WILL NOT find it in the products catalog (%programdata%\MySQL\MySQL Installer for Windows\Manifest\products.xml) even if you update the catalog through the installer.

This also has its implications as you will have to look for it by selecting Custom Install after Add in the dashboard and filter by Pre-Releases instead of the default selection which is Current GA. The Pre-Releases filter does not rely on the products.xml file to list available products (more on that later)

An special file called snippets which is only copied to your hard drive if you run one of the msi files I specified above: mysql-installer-community-8.0.0.0-dmr.msi or mysql-installer-web-community-8.0.0.0-dmr.msi is what you need to look for (%programdata%\MySQL\MySQL Installer for Windows\Manifest\Snippets), a line for MySQL-8.0.0 should appear in that xml such as: ...ProductSeries name="MySQL Server 8.0" cdnUrl="http://c...

If that is not true then you may probably have a problem with your local installer configuration, some how it got corrupted and its not copying all the files to its place. Normally this doesn't happen.
My suggestion for you in this case will be to: remove the current installer you have from your system by Control Panel >> Uninstall a program >> MySQL Installer - Community >> Uninstall, then delete the folder %programdata%\MySQL\MySQL Installer for Windows\, and finally run the 8.0.0.0-dmr.msi (listed above) of your preference once more. You should be able to validate the snippets file is correct now by following the instructions from above and run the installer normally.

The installed does show these products if installed correctly, follow images from below for further reference on how should it work:
1. https://s3.postimg.org/s6lccmogj/image.png (Where you begin).
2. https://s3.postimg.org/cmdym3ec3/image.png (Changin the product filters).
3. https://s3.postimg.org/k3n61b3v7/image.png (Setting product Maturity [Age] to Pre-Release).
4. https://s3.postimg.org/o1afqpqoj/image.png (Selecting Server 8.0 to be installed).

I hope any of these lines help you clarify any doubt or issue you had with our Windows Installer. Thanks for your concern and support!