This is mostly theoretical right now but I was wondering if it's possible to take existing data -- say, membership data (name + several fields of account data) -- and import that into a CPT with corresponding fields? I'm guessing this would have to be run outside of Toolset/WP in PHPMyAdmin, but is this even feasible? My strength is in CSS/HTML, so I will have to bring in outside help on it, I just wanted to know 1) can it be done 2) what are the steps on the Toolset side to prepare prior to migrating data.
Actually yes it is possible because its simply data and as long as its in the standard wordpress defined format or structure then the data will come up.
To prepare you site with toolset for the data all your need to do is recreate the CPT with Types giving it the same slug as the CPT in the data so it can be referenced.
So if the CPT slug matches the data entry and the fields all correspond based on slugs, will it just be recognized by WP? Or will it have to be imported somehow?
And what if it's on a different MySQL database from the one powering WP?
There needs to be a reference to the data so wordpress is able to recognise that the information is there. I the data was imported then it wouldnt show up on the backend, this is why the CPT need to be created in Types with the same slug so that it can be referenced.
Wordpress is only able to access its internal tables so an external data source won't work.