Name
LOAD TABLE...FROM MASTER
Synopsis
LOAD TABLE table
FROM MASTER
This 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.