title: how to alter a mysql innodb partition to use another key?
body: <p>I have a table with 5 hash(key_1) partitions. I want to change that, so it instead has 5 hash(key_2) partitions, but without losing data.</p>
  
  <p>How do I do this? I have searched but its hard to find confirmation that I dont lose data by deleting partitions.</p>