Syntax\n------\n\nRESTORE TABLE tbl_name [, tbl_name] ... FROM '/path/to/backup/directory'\n\nDescription\n-----------\n\nNote:\n\nLike BACKUP TABLE, this command was not reliable and has been removed from MariaDB. For doing a backup of MariaDB use mysqldump, mysqlhotcopy or XtraBackup. See Backing Up and Restoring.\n\nRESTORE TABLE restores the table or tables from a backup that was made with BACKUP TABLE. The\\\ndirectory should be specified as a full path name.\n\nExisting 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 tables. Restored tables are not replicated from master to slave.\n\nThe 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\\\nbacking up due to the need to rebuild the indexes. The more indexes the table has, the longer it takes.\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/table-statements/obsolete-table-commands/restore-table-removed