4.16 MySQL Upgrade (Windows)

Upgrading MySQL

  1. Stop Tomcat Starting and Stopping Tomcat on the Retain server.

  2. Perform a dump of the database.

  3. Download MySQL onto the server on which you want to install it.

  4. Install MySQL and configure the retain database. Refer to the appendix of the Windows Install Guide for instructions.

  5. Import the dump into the new retain database.

    1. Open a command window (cmd).

    2. Change directories to: C:\Program Files\MySQL\MySQL Server 5.0\bin (the beginning of the path depends upon where MySQL was installed).

    3. Type: mysql -u root -p retain < [path to dump file]\[dump filename]

      EX: mysql -u root -p retain < d:\dump\2013-12-11.sql

      NOTE:This assumes that the ..\MySQL\bin directory is in the path.

  6. (Optional) Reboot the server to clear memory; otherwise, just start Tomcat.