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: Difference between revisions

From LimeSurvey Manual

Cdorin (talk | contribs)
mNo edit summary
Marked this version for translation
 
(11 intermediate revisions by 6 users not shown)
Line 4: Line 4:


<!--T:5-->
<!--T:5-->
If you would like to update 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 in this scope.
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.


<!--T:6-->
<!--T:6-->
Line 10: Line 10:


<!--T:2-->
<!--T:2-->
After you clicked on it, a window will pop up, asking you where you would like to save the .sql database backup.
After you click '''Backup entire database''', a page will be displayed showing the database size and whether it can be downloaded directly.
 
<!--T:8-->
* 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.


<!--T:3-->
<!--T:3-->
For more about its usage, read our wikis on:
This backup is recommended when you wish to:
* [[Installation#Transferring an installation|how to transfer an LimeSurvey installation]];
* [[Transferring an installation|transfer your LimeSurvey application]] to another server;
* [[Installation#Upgrading from a previous version|how to upgrade an LimeSurvey installation]] (non-ComfortUpdate solution).
* [[Upgrading from a previous version|upgrade your LimeSurvey application]] (non-ComfortUpdate solution).
 
<!--T:7-->
<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>


<!--T:4-->
<!--T:4-->
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.
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.


</translate>
</translate>

Latest revision as of 23:08, 12 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.