MySQL Issue Upgrading from 3.5.7 or earlier on Windows

Issue

The first indication that an issue has occurred will be failure of the step that backs up the database in the form of an error message stating: mysqldump.exe has stopped working.

It is possible to proceed beyond that point by ignoring the error.  If it is chosen to ignore the error the next indication of an issue will be that after a potentially long period of "Contrast is starting up...", the console will start to display MySQL related errors such as the following:

WARN (MysqldResource.java:240) Unable to connect to the mysql database.

ERROR (DatabaseServer.java:135) [DEFAULT] Unable to start database

and possibly

WARN (MysqldResource.java:283) mysqld pid-file not found: C:\Program Files\Contrast\data\db\MysqldResource.pid

or

INFO (MysqldResource.java:490) launching mysqld (contrast-database)
INFO (MysqldResource.java:259) mysqld running as process: 1234

But Task Manager shows no indication that the process mysqld.exe is actually running.

The Windows Event Viewer will likely contain errors such as:

Faulting application name: mysqld.exe, version: 5.7.23.0, time stamp: 0x5b1a6a33
Faulting module name: MSVCR120.dll, version: 6.3.9600.19153, time stamp: 0x5b93ffa7
Exception code: 0xc0000135
Fault offset: 0x00000000000ecf30
Faulting process id: 0x810
Faulting application start time: 0x01d49643b64d8356
Faulting application path: C:\Program Files\Contrast\mysql\bin\mysqld.exe
Faulting module path: MSVCR120.dll
Report Id: f3fed3f0-0236-11e9-824c-0227f6a58826
Faulting package full name: 
Faulting package-relative application ID: 

Indicating that the mysqld.exe process consistently crashes on each attempt of the installer to restart it. 

Cause

The 3.5.8 release of Contrast includes an upgrade of MySQL from version 5.6 to 5.7.  The new version of MySQL has a dependency on the Visual C++ Redistributable Packages for Visual Studio 2013 which may not be installed on the system.

Resolution

Ensure that the appropriate version of the Visual C++ Redistributable Packages for Visual Studio 2013 are installed on the system.  For a 64-bit system, be sure to install the x64 version of the package even if the x86 version is already installed.