SET PERSIST default_collation_for_utf8mb4 = utf8mb4_general_ci;

--let $restart_parameters = restart: --character-set-server=utf8mb4 --collation-server=utf8mb4_general_ci
--source include/restart_mysqld.inc

CREATE DATABASE foo_db;
CREATE DATABASE db_foo;
USE foo_db;

SHOW SESSION VARIABLES LIKE '%character_set%';
SHOW SESSION VARIABLES LIKE '%collation%';

FLUSH LOGS;
--let $binlog_file = query_get_value("SHOW MASTER STATUS", File, 1)
--let $server_port = `SELECT @@port`

CREATE TABLE foo_implicit(
  id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  val VARCHAR(64) NOT NULL,
  PRIMARY KEY(id)
) ENGINE=InnoDB;
SHOW CREATE TABLE foo_implicit;
INSERT INTO foo_implicit VALUES(DEFAULT, 'юра');

delimiter |;
create procedure call_t1()
begin
select * from t1;
end
|
delimiter ;|

--exec $MYSQL_DUMP --column-statistics=0  --routines  --no-data foo_db foo_implicit | $MYSQL db_foo

--exec $MYSQL_BINLOG --read-from-remote-server --host=127.0.0.1 --port=$server_port --user=root --to-last-log $binlog_file | grep collation
--exec $MYSQL_BINLOG --read-from-remote-server --host=127.0.0.1 --port=$server_port --user=root --to-last-log $binlog_file | grep character

DROP TABLE foo_implicit;
DROP DATABASE foo_db;