> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/ha-and-performance/standard-replication/obsolete-replication-information/load-table-from-master-removed.md).

# LOAD TABLE FROM MASTER (removed)

## Syntax

```bnf
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](/docs/server/ha-and-performance/standard-replication/obsolete-replication-information/load-data-from-master-removed.md)\
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](/docs/server/clients-and-utilities/legacy-clients-and-utilities/mysqldump.md) or [mysqlhotcopy](/docs/server/clients-and-utilities/legacy-clients-and-utilities/mysqlhotcopy.md).\
The latter requires Perl and two Perl modules (DBI and DBD:mysql) and works for [MyISAM](/docs/server/server-usage/storage-engines/myisam-storage-engine.md) and [ARCHIVE](/docs/server/server-usage/storage-engines/archive.md) 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
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

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

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.