Is checkForServerUpgrade available in mySQL 5.7?

Question

Specifically, is checkForServerUpgrade() available in google cloud's sql for mySQL? When I log into the cloud shell, connect to the db, and run the command, I get this.

I'm trying to update a db from MySQL 5.7 to 8.0, and I'm following the Google documentation for an in place update.

Shadow · Accepted Answer · 2025-03-31 05:55:12Z

1

You are trying to execute checkForServerUpgrade from mysql's command line client, which does not support much beyond sql statements.

checkForServerUpgrade is only available in mysql shell utilities. Mysql shell utilities are only available in javascript and python modes, not in sql mode in mysql shell. Mysql shell can be started with mysqlsh command, not with mysql.

GCP's guidance to upgrade mysql correctly refers to mysql shell and its documentation, so you probably just mixed mysql cli up with mysql shell.

edited Mar 31 at 5:55

answered Mar 31 at 5:40

Shadow

34.5k10 gold badges67 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is checkForServerUpgrade available in mySQL 5.7?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related