Hi all. I have an FP application that makes use of a MySQL db that resides on a remote server.
Locally, I have MySQL installed on Windows and from time to time I use a third-party program to copy all the MySQL tables from the remote server to my local windows installation. This works well but has several manual steps and cannot be run unattended.
What I would like to do is accomplish the same thing, but within my FP app. But I'm not sure where to begin.
Since I can run queries on the remote MySQL db and the local MySQL db, I'm assuming there must be a way to determine what tables exist along with their structure, and recreate those tables locally. And I guess the data as well?
Like I said I'm unsure where to begin, so your help would be greatly appreciated.