MySQL databases are prevalent across many Linux distributions. It is possible to back them up through JAMSAgentX.
Creating the Job
To start, click the Jobs button on the sidebar under Definitions to create a new job. Name it something such as MySQL Backup. Choose the Execution Method SSHAgent.
The Username chosen should be the one that connects to the Linux node. The following example could be utilized for the Source:
#!/bin/bash mysqldump -u <<user>> -p<<password>> --all-databases | gzip > <<direc>>/backup_`date '+%m-%d-%Y'`.sql.gz
After manipulating any other Job Properties, toggle the Checkbox to edit the Job definition after adding. Here, go to the Parameters tab and click Add on the bottom. The first parameter will be user, insert it as shown:
The data type is simply Text. The next parameter is password, and is entered as follows:
Again, the data type is Text. The last parameter is direc, and is entered as such:
The data type is Text for this as well. Click the Save button to finish.
Submitting the Job
Now that the job has been created, it is time to submit it. Click the Submit button and a dialog box with the parameters will come up.