When backing up the bayes database, do I need a path or a filename?

Both. You will need to tell spamtrainer the filename and its location. For example: /volumes/mydisk/mydirectory/myfile