# 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" %}