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

# RESTORE TABLE (removed)

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

## Syntax

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

## Description

#### Note:

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

`RESTORE TABLE` restores the table or tables from a backup that was made with [BACKUP TABLE](/docs/server/reference/sql-statements/table-statements/obsolete-table-commands/backup-table-removed.md). 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](/docs/server/server-usage/storage-engines/myisam-storage-engine.md) 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" %}