search

thegrumpys / odop

Open Design Optimization Platform (ODOP) - Coil spring design app; mechanical springs; compression spring, extension spring, torsion spring
https://www.springdesignsoftware.org
MIT License
4 stars 5 forks source link

Upgrade MySQL from 5.7 to 8.0 #899

Open grumpyinca opened 5 months ago

grumpyinca commented 5 months ago

Create new V8 JAWS DB database

Connection Info
Connection String

mysql://agquyk27bpv35s60:cqdmcrpmrsyuef2o@ohunm00fjsjs1uzy.cbetxkdyhwsb.us-east-1.rds.amazonaws.com:3306/pgyb3toxyk59fz2w

You can use your connection information to connect manually through a client such as HeidiSQL to administer your database.

Property    Value   Action
Host    ohunm00fjsjs1uzy.cbetxkdyhwsb.us-east-1.rds.amazonaws.com   
Username    agquyk27bpv35s60    
Password    See Heroku addons   
Port    3306    
Database    pgyb3toxyk59fz2w

Updated create.sql for MySQL 8.0 by changing Collation and removing Int width

create.sql.zip

Also ran compression spring load.sql

And was able to bring up the application successfully.