(mysql.info.gz) LOAD TABLE FROM MASTER
Info Catalog
(mysql.info.gz) LOAD DATA FROM MASTER
(mysql.info.gz) Replication Slave SQL
(mysql.info.gz) 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 master to the slave. This statement
is implemented mainly for debugging of `LOAD DATA FROM MASTER'. It
requires that the account used for connecting to the master server has
the `RELOAD' and `SUPER' privileges on the master and the `SELECT'
privilege on the master table to load. On the slave side, the user
that issues `LOAD TABLE FROM MASTER' should have privileges to drop and
create the table.
The conditions for `LOAD DATA FROM MASTER' apply here, too. 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.gz) LOAD DATA FROM MASTER
(mysql.info.gz) Replication Slave SQL
(mysql.info.gz) MASTER_POS_WAIT
automatically generated byinfo2html