# RESTORE TABLE (removed)

{% hint style="warning" %}
`RESTORE TABLE` was removed and is no longer a part of MariaDB.
{% endhint %}

## Syntax

```sql
RESTORE TABLE tbl_name [, tbl_name] ... FROM '/path/to/backup/directory'
```

## Description

#### Note:

Like [BACKUP TABLE](https://mariadb.com/docs/server/reference/sql-statements/table-statements/obsolete-table-commands/backup-table-removed), this command was not reliable and has been removed from MariaDB. For doing a backup of MariaDB use [mysqldump](https://mariadb.com/docs/server/clients-and-utilities/legacy-clients-and-utilities/mysqldump), [mysqlhotcopy](https://mariadb.com/docs/server/clients-and-utilities/legacy-clients-and-utilities/mysqlhotcopy) or [XtraBackup](https://mariadb.com/docs/server/clients-and-utilities/legacy-clients-and-utilities/backing-up-and-restoring-databases-percona-xtrabackup/percona-xtrabackup-overview). See [Backing Up and Restoring](https://mariadb.com/docs/server/server-usage/backup-and-restore).

`RESTORE TABLE` restores the table or tables from a backup that was made with [BACKUP TABLE](https://mariadb.com/docs/server/reference/sql-statements/table-statements/obsolete-table-commands/backup-table-removed). The\
directory should be specified as a full path name.

Existing tables are not overwritten; if you try to restore over an existing table, an error occurs. Just as for `BACKUP TABLE`,`RESTORE TABLE` works only for [MyISAM](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine) tables. Restored tables are not replicated from master to slave.

The backup for each table consists of its .frm format file and `.MYD` data file. The restore operation restores those files, and then uses them to rebuild the `.MYI` index file. Restoring takes longer than\
backing up due to the need to rebuild the indexes. The more indexes the table has, the longer it takes.

<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/reference/sql-statements/table-statements/obsolete-table-commands/restore-table-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.