User35838176 posted
The easiest way would be to do an SQL dump of the data - update the schema and do a bulk import of the data.
However, the proper way of doing this is rather coy - you should be writing the schema so that it can be readily updated, and think about the future when designing your database.
Dave