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 installation to another server;
- upgrade your LimeSurvey installation (non-ComfortUpdate solution).

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