Name
LOAD DATA FROM MASTER
Synopsis
LOAD DATA FROM MASTER
This statement makes a
copy of all the databases on the master server (except the
mysql database) and then copies them to the
slave servers. This statement will get a global read lock on all
tables while it takes a snapshot of the databases. It will release
the lock before copying them to the slaves. The
MASTER_LOG_FILE
and the
MASTER_LOG_POS
variables will be updated so that
the slave knows where to begin logging. This statement currently
works only with MyISAM tables, but will eventually work with InnoDB
tables in future releases. The user for the connection must have
RELOAD
, SELECT
, and
SUPER
privileges on the master server. The user
must also have CREATE
and DROP
privileges on the slave server.
For large databases, increase the
values of the net_read_timeout
and
net_write_timeout
variables with the
SET
statement. To load a specific table from the
master server, use the LOAD TABLE...FROM MASTER
statement.
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.