LOAD TABLE tbl_name
FROM MASTER
This feature is deprecated and should be avoided. It is subject to removal in a future version of MySQL.
Since the current implementation of LOAD DATA FROM
MASTER
and LOAD TABLE FROM MASTER
is very limited, these statements are deprecated in versions 4.1
of MySQL and above. We will introduce a more advanced technique
(called “online backup”) in a future version. That
technique will have the additional advantage of working with
more storage engines.
For MySQL 5.1 and earlier, the recommended alternative solution
to using LOAD DATA FROM MASTER
or
LOAD TABLE FROM MASTER
is using
mysqldump or mysqlhotcopy.
The latter requires Perl and two Perl modules
(DBI
and DBD:mysql
) and
works for MyISAM
and
ARCHIVE
tables only. With
mysqldump, you can create SQL dumps on the
master and pipe (or copy) these to a mysql
client on the slave. This has the advantage of working for all
storage engines, but can be quite slow, since it works using
SELECT
.
Transfers a copy of the table from the master to the slave. This
statement is implemented mainly debugging LOAD DATA
FROM MASTER
operations. To use LOAD
TABLE
, the account used for connecting to the master
server must have the RELOAD
and
SUPER
privileges on the master
and the SELECT
privilege for the
master table to load. On the slave side, the user that issues
LOAD TABLE FROM MASTER
must have privileges
for dropping and creating the table.
The conditions for LOAD DATA FROM MASTER
apply here as well. For example, LOAD TABLE FROM
MASTER
works only for MyISAM
tables. The timeout notes for LOAD DATA FROM
MASTER
apply as well.
User Comments
the the big bold red comment. In my experience:
Works ok from 4.x to 4.x and from 5.0.x to 5.0.x. But will not work at all if you load a table from 4 to 5. It will just create an empty table.
Add your own comment.