Unable to import dump on mysql alibaba

alibabacloud
,
1

I exported the data as dump from alibaba test MySQL instance.

Now when I try to import the dump into the new alibaba resources, I get the following error:

ERROR 1227 (42000) at line 20: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Please solve this asap because the old resources are going to expire soon.

PS: Dump is working fine on local.

2

Sorry for this unwanted question. I solved it.

Apparently the root user on ApsaraDB is not allowed to execute the following statement:

SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN;

Thanks anyway :smiley: