What's the recommended way to keep project's SQL database backup in Bitbucket repository?

[Chris Fore]

We have several repositories for CMS sites, which include files and a database. What's the best keep a SQL Server/MySQL database backup file in the repository? As a download?

[Seth · Accepted solution]

That depends on whether you want them versioned or not. If you would like to access old copies of database backups, it would make more sense to add them to a special folder in the repository itself, where they get committed and pushed to Bitbucket.

If you only care about the current version, then uploading them as downloads makes a little more sense, but I would consider storing them somewhere else entirely. Bitbucket is not designed or optimized as backup storage.

My project versions the SQL database definition files, but not backups of production data.