DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH
 

(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