Running MySQL Utility Commands on Remote Server

[Peter Reid]

Hi Sarah

Thanks again for another of your responses below.

I assumed that the MySQL utility programs could be used only where 
the rest of MySQL had been installed.  From what you're saying, these 
utilities are completely standalone and independent of any other 
material installed as part of the MySQL server.  Is this the case, or 
does it mean that MySQL has to be installed on each client system as 
well, not to function as a local MySQL server, but simply to provide 
support for the utilities?

Cheers

Peter

>I do this by including a copy of mysqldmp in with the application. 
>In Standalone setttings, in the Copy file section, add the mysqldump 
>file to the list and it will automatically become part of your 
>application and be useable by the app. With OS X, it is inside the 
>bundle. For testing purposes, I put a copy of mysqldump in the 
>folder with the stack file.
>
>Here is the script I use:
>
>   put the fileName of stack "MailOpener" into tPath
>   set the itemDel to "/"
>   put "mysqldump" into last item of tPath
>   put "'" & tPath & "' --host='" & dbAddr & \
>   "' MailingList names address flags topics deletions" into tCmd
>   put " --user='" & dbUser after tCmd
>   put "' --password='" & dbPass after tCmd
>   put "' -a -l -r '" & tFile & "'" after tCmd
>
>   get shell(tCmd)
>
>Cheers,
>Sarah

-- 
Peter Reid
Reid-IT Limited, Loughborough, Leics., UK
E-mail: preid at reidit.co.uk