Replicate table from an existing FileMaker db to an empty MySql db table.
We have a pre-existing internal FileMaker database that is used to keep up with grant obligations and status. We also have a WIMP server hosting our webs. We have been manually updating our shipping log, which is a lot of redundant work, so I am automating it via php scripts. My issue is that I need the pre-existing data in the empty MySql db. I havent had any luck exporting from FileMaker, and I've tried to populate it through adding the required fields and a relationship on the key. Still no luck.. I have googled this topic so long that their logo is etched in my corneas. What is the best route to accomplish this? I need for the MySql table to automatically be updated when the Filemaker table is altered. Is this possible??
Thanks for the help.