LOAD TABLE...FROM MASTER

This MySQL statement has been deprecated and will be removed from future releases of MySQL since it has many problems.

Syntax

Below is the syntax for this command. Text within square brackets (i.e, [ and ] ) are optional. Choices are separated by bars (i.e, | ). Ellipses preceded by a comma indicates a repeating pattern. Ellipses before or after syntax are used to highlight a relevant except from the larger syntax. Text displayed in italic letters represent text that should be replaced with the specific names related to the database (e.g., column with the name of the column).

LOAD TABLE table FROM MASTER

Explanation

This statement has been deprecated and will be removed from future releases of MySQL since 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 like mysqldump to copy the data from the master. This method is described in detail in my tutorial article Backing Up MySQL.