4,348
edits
MySQL: Difference between revisions
m
→Restoring a table from .frm and .ibd files
| Line 195: | Line 195: | ||
#: Create the table using the generated script, or previously existing script that matches the backup structure. | #: Create the table using the generated script, or previously existing script that matches the backup structure. | ||
# Replace .ibd file. | # Replace .ibd file. | ||
#: Remove the newly created .idb file by executing the following: <source lang="mysql">> ALTER TABLE mytablename | #: Remove the newly created .idb file by executing the following: <source lang="mysql">> ALTER TABLE mytablename DISCARD TABLESPACE;</source> | ||
#: Copy the restored .ibd file into the folder that contains the .ibd file. | #: Copy the restored .ibd file into the folder that contains the .ibd file. | ||
# Reactivate the table | # Reactivate the table | ||