MySQueaL Resources

resources for mysql admins and developers who are squealing for help

More Resources

Main Doc Pages
Comments
MySQL columns: everywhere I look are tables and columns; life is filled with databases of information to be ordered and grouped. (Ca'Grande, Milan, Italy)

LOAD TABLE...FROM MASTER Statement

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

hits past month: 8 ;  last updated: may 4, 2009 - 2:34am ;  parent: MySQL Replication

Syntax

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.

There are no examples for this page of our documentation. Return to MySQL Replication page of our MySQL Documentation