AnsweredAssumed Answered

FileMaker System-level Script (Mac) copy database

Question asked by MichaelReese on Dec 16, 2011
Latest reply on Dec 19, 2011 by MichaelReese

Title

FileMaker System-level Script (Mac) copy database

Your post

Hello everyone,

I'm looking for a way to make a copy of a production database and copy it to a test database.  Would like to update the Test database maybe every 30days or so.

I have created a script and it works fine when I run it from the Mac in terminal.

I then used the FileMaker Scheduler to run a system script and I get the message Aborted by user. (I have to use the system admin account to get this message)

If I try to use the default account that FileMaker uses to run the script I receive invalid account.  Default account is fmserver.

I have another script that is set to run with the default account and it works fine.

 

Here is the script.

 #!/bin/bash

#

source="/Library/FileMaker Server/Data/Databases/Prod/Database_Prod.fp7"

destination="/Library/FileMaker Server/Data/Databases/Test/Database_Test.fp7"

cp -f "$source" "$destination"

exit 0

 

Thanks for your time and help

Outcomes