Magento Open Source, 1.9.x
Creating a Backup

Database backup files are compressed using the .gz format. The .tgz format is used for system, database, and media backups. Backup files are stored in the var/backups directory in your Magento file system. The files that are stored in the /var/cache, /var/log, /var/session and /var/report folders are excluded from the backup.

Create a Backup