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: [EMAIL PROTECTED] _______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to