Backup entire database: Difference between revisions
From LimeSurvey Manual
mNo edit summary |
No edit summary |
||
| Line 5: | Line 5: | ||
<!--T:5--> | <!--T:5--> | ||
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. | ||
<!--T:6--> | <!--T:6--> | ||
<center>[[File:Backup entire database configuration.png]]</center> | <center>[[File:Backup entire database configuration.png]]</center> | ||
<!--T:2--> | |||
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. | |||
<center>[[File:Backup_database_size_check_success.png|600px]]</center> | |||
* If the database is **too large**, a yellow warning message will appear, informing you that a manual backup is required using a database client. | |||
<center>[[File:Backup_database_size_check_warning.png|600px]]</center> | |||
<!--T:3--> | <!--T:3--> | ||
| Line 23: | Line 27: | ||
<!--T:4--> | <!--T:4--> | ||
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. | ||
</translate> | </translate> | ||
Revision as of 18:01, 31 January 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.
This backup is recommended when you wish to:
- transfer your LimeSurvey application to another server;
- upgrade your LimeSurvey application (non-ComfortUpdate solution).
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.