There are two types of backup: System Backup and User Backup. In addition to the system backups, we recommend maintaining user backups for your records. Here is a list of differences between the two backup file types:
How Backup Files are Created:
You must use the appropriate filename extension when renaming any back-up file: MySQL files use the .sql extension. SQL Server files use the .bak extension.
For more information, see Backing up and Restoring MySQL or MSSQL Databases.