Backup entire database/en: Difference between revisions
From LimeSurvey Manual
Updating to match new version of source page |
Updating to match new version of source page |
||
Line 3: | Line 3: | ||
If you would like to upgrade your LimeSurvey installation or transfer it to another location/server, we highly recommend that you back up all your data (questions, participants, responses, etc.). You can use the '''Backup entire database''' function for this purpose. | If you would like to upgrade your LimeSurvey installation or transfer it to another location/server, we highly recommend that you back up all your data (questions, participants, responses, etc.). You can use the '''Backup entire database''' function for this purpose. | ||
<center>[[File:Backup entire database configuration.png]]</center> | <center>[[File:Backup entire database configuration.png]]</center> | ||
After you click '''Backup entire database''', a page will be displayed showing the database size and whether it can be downloaded directly. | |||
* If the database size is '''small enough''', you will see a green confirmation message indicating that the database is ready for immediate download. Clicking the '''Yes - download now!''' button will start the download of the `.sql` backup file. | |||
* If the database is '''too large''', a yellow warning message will appear, informing you that a manual backup is required using a database client. Please note, that you can configure this size limit in [[Global settings]]/Storage. | |||
This backup is recommended when you wish to: | This backup is recommended when you wish to: | ||
Line 16: | Line 17: | ||
<div class="simplebox">[[File:help.png]] '''Note:''' If you use the [[ComfortUpdate#Using_ComfortUpdate|ComfortUpdate]] functionality, a database backup is automatically created in the /tmp folder.</div> | <div class="simplebox">[[File:help.png]] '''Note:''' If you use the [[ComfortUpdate#Using_ComfortUpdate|ComfortUpdate]] functionality, a database backup is automatically created in the /tmp folder.</div> | ||
This option is also | This option is also useful when making significant changes to LimeSurvey settings or code modifications. Creating a backup ensures that you can restore your data in case any issues arise. |
Latest revision as of 16:21, 14 April 2025
General
If you would like to upgrade your LimeSurvey installation or transfer it to another location/server, we highly recommend that you back up all your data (questions, participants, responses, etc.). You can use the Backup entire database function for this purpose.

After you click Backup entire database, a page will be displayed showing the database size and whether it can be downloaded directly.
- If the database size is small enough, you will see a green confirmation message indicating that the database is ready for immediate download. Clicking the Yes - download now! button will start the download of the `.sql` backup file.
- If the database is too large, a yellow warning message will appear, informing you that a manual backup is required using a database client. Please note, that you can configure this size limit in Global settings/Storage.
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 useful when making significant changes to LimeSurvey settings or code modifications. Creating a backup ensures that you can restore your data in case any issues arise.