As of 2025, most of the time, when all the scripts are properly made, this error can still happen due to macOS security, and can be fixed by authorizing the proper programs, (i.e. for example zsh, mysqldump in my case) in in system settings->security and confidentiality->complete disk access.