Partitioning a table in mysql after creation
Posted
by erik
on Stack Overflow
See other posts from Stack Overflow
or by erik
Published on 2010-06-14T20:18:13Z
Indexed on
2010/06/14
20:22 UTC
Read the original article
Hit count: 246
mysql
|partitioning
I have a table with a bunch of data already in it. I know how to create a partitioned table or alter an already existing partitioned table, but can I add partitions to a table after it has been created, has data in it, without losing the data?
The other option is to dump all the data, recreate the table with the partitions and then insert it all back it. Is that the only way?
Thanks.
© Stack Overflow or respective owner