I was asked to implement a feature that allows a user to perform a database dump using a push button on one of the FactoryPMI screens. I’ve read up on the dumping process in general and have found that there is really no query to do it. All examples have referenced the ‘mysqldump’ application that comes with the server.
My question is: Am I able to send a system command to the computer running my FactoryPMI gateway, specifically the mysqldump command?
Also, if there is any way I can do this through a SQL query that would be preferred, as the mysqldump route would not provide any feedback to the user.
Thanks in advance.