# LOAD TABLE FROM MASTER (removed)

## Syntax

```sql
LOAD TABLE tbl_name FROM MASTER
```

## Description

This feature has been removed from recent versions of MariaDB.

Since the current implementation of [LOAD DATA FROM MASTER](https://mariadb.com/docs/server/ha-and-performance/standard-replication/obsolete-replication-information/load-data-from-master-removed)\
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 MariaDB and MySQL 5.1 and earlier, the recommended alternative solution to\
using `LOAD DATA FROM MASTER` or`LOAD TABLE FROM MASTER` is using [mysqldump](https://mariadb.com/docs/server/clients-and-utilities/legacy-clients-and-utilities/mysqldump) or [mysqlhotcopy](https://mariadb.com/docs/server/clients-and-utilities/legacy-clients-and-utilities/mysqlhotcopy).\
The latter requires Perl and two Perl modules (DBI and DBD:mysql) and works for [MyISAM](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine) and [ARCHIVE](https://mariadb.com/docs/server/server-usage/storage-engines/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](https://github.com/mariadb-corporation/mariadb-docs/blob/main/reference/sql-statements-and-structure/sql-statements/account-management-sql-commands/grant.md#global-privileges) 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.

<sub>*This page is licensed: GPLv2, originally from*</sub> [<sub>*fill\_help\_tables.sql*</sub>](https://github.com/MariaDB/server/blob/main/scripts/fill_help_tables.sql)

{% @marketo/form formId="4316" %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/server/ha-and-performance/standard-replication/obsolete-replication-information/load-table-from-master-removed.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.