Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Upgrade MySQL from 5.7 to 8.0 #899

Open
grumpyinca opened this issue Jan 13, 2024 · 0 comments
Open

Upgrade MySQL from 5.7 to 8.0 #899

grumpyinca opened this issue Jan 13, 2024 · 0 comments
Assignees
Milestone

Comments

@grumpyinca
Copy link
Contributor

grumpyinca commented Jan 13, 2024

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.

@grumpyinca grumpyinca added this to the ODOP 4.6 milestone Jan 13, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants