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