Promote MySQL Table Partition to Table My Google Searching skills were not enough to find a solution to this. If possible, how can I promote a partition on a table to a table on its own?
Let's assume I have part0, part1, and part2. Is there any ALTER TABLE that I can give that converts part0 to a new table?
My thought process was, since the data is already existing in a separate file on disk, the table creation process may be faster than creating a new table using a SELECT query.
Yes, a PARTITION is a TABLE.  However, it takes some special commands to turn a partition into a table or vice versa.
See &quot;transportable tablespaces&quot; and FLUSH TABLES ptable FOR EXPORT; ALTER TABLE ptable DISCARD TABLESPACE; ALTER TABLE ptable IMPORT TABLESPACE.  The details are different between MySQL 5.6 and 5.7+.
http://mysql.rjweb.org/doc.php/partitionmaint#use_cases_for_partitioning has links to a few places that discuss the techniques.