I decided to ask this question as searching online left me really overwhelmed and not knowing which direction to take.
I am about to tackle a project that has its own custom database (finished e-r design) in MySQL, and I want to use Wordpress as its CMS.
Can I make custom post types but pull/save records from/to the custom database? if so, any link to resources would be much appreciated, like:
- Should I merge the databases or can I keep working them independently?
- For the custom post type's admin area, how do I use this to pull/save entries from/to the custom database's table(s) for individual records?
- Do I use/make custom fields in the custom post types and then rely on some hook to pull/save them from/to the custom database?
- Will I be able to delete the posts in Wordpress and also delete the corresponding entry in the custom database?
Is there a wiser way to go about this whole thing? I'm very open to suggestions/informed guidance.
I found the following resources, but I just can't pull them all together:
- https://stackoverflow.com/questions/7538337/save-the-data-of-custom-metabox-to-database - but how do I do this for a custom database?
- http://www.deluxeblogtips.com/meta-box - is this something I should look at or is it overkill?
- http://Wordpress.org/support/topic/migrate-from-custom-database-to-Wordpress-database - this kind of hits the spot but not quite; if I want to work on the custom database without merging it with Wordpress what do I do?
Again, I'm just fumbling my way around these options as these are what I've come across so far. If someone knows a better/more correct way to tackle the whole problem and not just piecing-together disparate info ending up with a frankensteined setup then I would love to hear what you have in mind.