create database foo; create table foo.bar(id int); create table foo.baz(id int); CREATE TABLE IF NOT EXISTS log_pos ( `host` varchar(60) NOT NULL, `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `log_file` varchar(32) DEFAULT NULL, `log_pos` int(11) DEFAULT NULL, `master_host` varchar(60) DEFAULT NULL, `master_log_file` varchar(32) DEFAULT NULL, `master_log_pos` int(11) DEFAULT NULL, PRIMARY KEY (`host`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; --exec perl $MYSQLHOTCOPY --host=127.0.0.1 --port=13000 --user=root --record_log_pos=test.log_pos foo $MYSQL_TEST_DIR/var/tmp