Name
LOAD TABLE...FROM MASTER
Synopsis
LOAD TABLE table FROM MASTERUse this statement
to copy a MyISAM table from the master server to a slave server. The
user for the connection must have RELOAD and
SUPER privileges as well as
SELECT privileges for the table on the master
server. The user must also have CREATE and
DROP privileges on the slave server.
Get MySQL in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
