migrating from Mariadb: Variable 'sql_mode' can't be set

[jameslast]

Hello All,

I apologize in advance if this has been posted before.

I'm migrating databases from Linux/Mariadb to Cloud SQL. I exported the database with the command:

mysqldump -u root database --routines > database.sql

In Cloud SQL a created a database with character set utf8 and default collation.

When importing the sql file into the database I get EM:  Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'

I find lots of posts when googling this, but not many in relation to Cloud SQL. Is there a Cloud SQL-specific way of solving this?

Many thanks for any help.

Greetngs, j.

[jameslast · Accepted solution]

Hello,

replying to my own post:

the first part was easy ---> I got rid of NO_AUTO_CREATE_USER with command:

sed -i 's/NO_AUTO_CREATE_USER//' mysqldump.sql 

After that I had to jump through a lot more hoops to get the sql file into Cloud Sql but this was all due to an older Mariadb syntax and a newer 8.0 Mysql syntax.

So no Cloud Sql specific problem and no Cloud Sql specific solution!

Greetings, j.