Binary log events for the ‘mydb1’ schema must be copied to a different schema name ‘mydb2’.
Which command will do this?
mysqlbinlog --rewrite-db=’mydb1->mydb2’ | mysql
mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql
mysqlbinlog --rewrite-db=’mydb1’ --rewrite-db=’mydb2’ | mysql
mysqlbinlog --read-from-remote-server --raw | sed ‘s/mydb1/mydb2/g’ | mysql
Submit