Posted at

rdsをslaveにするときに躓く点

More than 1 year has passed since last update.


dump時

--master-data=2にする


パラメータグループ

You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

log_bin_trust_function_creatorsを1にする


dumpデータ編集

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

DEFINE=を消す