Backup entire database
From LimeSurvey Manual
General
If you would like to upgrade your LimeSurvey installation or transfer it to another location/server, we highly recommend you to back up all your data (questions, participants, responses, etc.). You can use the Backup entire database function for this purpose.

After you clicked on it, a window will pop up, asking you where you would like to save the .sql database backup.
This backup is recommended when you wish to:
- transfer your LimeSurvey application to another server;
- upgrade your LimeSurvey application (non-ComfortUpdate solution).

This option is also used when changes on different settings (e.g. in the code) are done. In this way, you secure your data in case the installation breaks up.