在MySQL数据库之间迁移和处理数据的更快方法

I am trying to normalize a schema. I have one MySQL database used in a CMS and the data schema is very problematic. For example, in order to get all properties and sub-properties of an entity, I have to query several tables and also do some post-DB processing. There are a couple sub-properties which are stored in a JSON string in one field, and when you parse that JSON it gives you foreign key IDs to another table in the DB. It is kind of a mess with talking to the db, then processing stuff, then talking to the DB again for the rest.I am trying to normalize a schema. I have one M