Using the specified Back Up options, you can generate the SQL database dump file of your SupportSuite database.
Add “CREATE TABLE” SQL statements: This option if enabled, will add the CREATE TABLE <tablename> SQL query before the insert statements.
Compress SQL Dump: This option if enabled, will compress the SQL dump file using GZIP. It is highly recommended that you do not change this setting.
GZIP is a compression utility designed to be a replacement for compress with much better compression and freedom from patented algorithms.
Once you have set the above settings, you can now generate the back up by clicking on the ‘Generate Backup‘ tab.
Other Back Up Options:
You can use this section to back up the system database, however it is recommended you generate the back of your database from the MySQL CLI using the mysqldump command.
Restoring the SQL dump:
You can restore the generated back up file into your MySQL database using a third party software ‘PHPMyAdmin‘ or from the MySQL CLI using the mysql command.
For more information refer to MySQL.com