title: AWS Aurora Migration; MySQL Partitioned Tables Don't Restore
body: <p>We've just spun up an Aurora instance using a MySQL snapshot. Everything looks good except for our partitioned tables. In every case, partitioned tables appear in SHOW TABLES output but if we SELECT from the table, or run DESCRIBE or SHOW CREATE TABLE, we get an error saying the table does not exist. If we attempt to run queries against any partitioned table from a PHP client, Aurora throws the same error.</p>
  
  <p>If we run a CREATE TABLE statement that uses partitions in the Aurora database, the statement runs without error.</p>
  
  <p>Is there an issue with migrating partitioned tables? Anyone had a similar experience? Since Aurora is designed with really large databases in mind, I assume others are migrating partitioned tables.</p>