x

Main chapters

  1. LimeSurvey Cloud vs LimeSurvey CE
  2. LimeSurvey Cloud - Quick start guide
  3. LimeSurvey CE - Installation
  4. How to design a good survey (Guide)
  5. Getting started
  6. LimeSurvey configuration
  7. Introduction - Surveys
  8. View survey settings
  9. View survey menu
  10. View survey structure
  11. Introduction - Questions
  12. Introduction - Question Groups
  13. Introduction - Surveys - Management
  14. Survey toolbar options
  15. Multilingual survey
  16. Quick start guide - ExpressionScript
  17. Advanced features
  18. General FAQ
  19. Troubleshooting
  20. Workarounds
  21. License
  22. Version change log
  23. Plugins - Advanced
 Actions

Backup entire database/en: Difference between revisions

From LimeSurvey Manual

FuzzyBot (talk | contribs)
Updating to match new version of source page
FuzzyBot (talk | contribs)
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.


After you click '''Backup entire database''', a window will displayed, asking you where you would like to save the .sql database backup.
* 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 used when changes on different settings (e.g. in the code) are done. In this way, you secure your data in case there are issues with the application.
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:

Note: If you use the ComfortUpdate functionality, a database backup is automatically created in the /tmp folder.

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.