a0f6f98d-8a5e-40ef-9ca4-4a2f6c9ef87f

may i asked why you deployed mysql 5.7 over mysql 8?

so I can do the legacy authentication

mysqlnativepassword

But uhh, that didn't work so now I'm on damage control

mysql 5.7 is several major versions behind mysql 8 though and mysqlnativepassword was only deprecated in 8.0.34, why the jump back to 5.7?

I got this:

https://github.com/dimitri/pgloader/issues/782

yes i know, but why the jump back to 5.7

🫠

oof, never blindly trust a comment that says to downgrade something several major versions

you can try to set innodb_fast_shutdown to 0

you can try to set innodbfastshutdown to 0

How can I do that without access to the volume? Just an arg?

yes

nope, didnt work, try manually going through the next versions 5.7 -> 5.8 -> etc

but please come to terms that you could have irreversibly lost your data

https://tenor.com/view/think-about-it-use-your-brain-use-the-brain-think-brain-gif-7914082

luckily i was smart and did a backup

then just restore from that and call it a day

how does one do that

if I have no volume access

just spin up another instance of mysql?

yes and then restore the backup to that

any way to start it at version 8 and not 9?

no, the template deploys v9, youd have to downgrade it after the fact

well that is upsetting

2024-12-31T19:20:18.770972Z 1 [ERROR] [MY-014061] [InnoDB] Invalid MySQL server downgrade: Cannot downgrade from 90100 to 80403. Downgrade is only permitted between patch releases.

wait

yeah

ty

!s