Sample Header Ad - 728x90

Will renaming a MySQL table to another database result in a full table copy operation on disk?

3 votes
1 answer
1092 views
I understand that renaming a table within the same database will not generally result in a table copy... It's not clear to me if this holds true for renaming across databases. For reference, I want to move/rename a ~1TB table to a different database, and I don't want to initiate a huge copy operation. Will renaming a MySQL table to another database result in a full table copy operation on disk? Please provide an explanation or references if possible.
Asked by Dan (235 rep)
Aug 10, 2021, 04:03 PM
Last activity: Aug 10, 2021, 05:19 PM