(mysql.info) load-table-from-master

Info Catalog

(mysql.info) load-data-from-master

(mysql.info) replication-slave-sql

(mysql.info) master-pos-wait

 
 13.6.2.3 `LOAD TABLE TBL_NAME FROM MASTER' Syntax
 .................................................
 
      LOAD TABLE TBL_NAME FROM MASTER
 
 Transfers a copy of the table from the master to the slave.  This
 statement is implemented mainly debugging `LOAD DATA FROM MASTER'
 operations. To use `LOAD TABLE', the account used for connecting to the
 master server must have the `RELOAD' and `SUPER' privileges on the
 master and the `SELECT' privilege for the master table to load. On the
 slave side, the user that issues `LOAD TABLE FROM MASTER' must have
 privileges for dropping and creating the table.
 
 The conditions for `LOAD DATA FROM MASTER' apply here as well. For
 example, `LOAD TABLE FROM MASTER' works only for `MyISAM' tables. The
 timeout notes for `LOAD DATA FROM MASTER' apply as well.
 

Info Catalog

(mysql.info) load-data-from-master

(mysql.info) replication-slave-sql

(mysql.info) master-pos-wait