Name
LOAD TABLE...FROM MASTER
Synopsis
LOAD TABLE table FROM MASTERThis statement has been deprecated and will be removed from
future releases of MySQL because it has many problems. It was meant 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.
Instead of using this statement, use a utility such as
mysqldump to copy the data from the master. This
method is described in detail in the tutorial section at the start of
this chapter.
Get MySQL in a Nutshell, 2nd Edition 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.
