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.
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.
Share Improve this question asked Mar 31 at 3:30 Mike DeeMike Dee 5891 gold badge7 silver badges17 bronze badges2 Answers
Reset to default 1You 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.
util.checkForServerUpgrade('[email protected]:3306',{"password":"password","targetVersion":"8.0.27", "outputFormat":"JSON", "configPath":"/mysql/data/306/my.cnf"})