how to restore old data?

More
5 years 1 month ago #123315 by charleyhankins
Hi! I had to reinstall Limesurvey fresh. However, I need the data from my previous installations. How do I restore that? Do I just replace the database with the old one in phpMyAdmin?
The topic has been locked.
LimeSurvey Partners
More
5 years 1 month ago #123316 by gabrieljenik
Hi !

If bot installations are the same version, then, you can try pointing the connection string to the old DB.
I recommend to keep the new DB for a while until the new installation is stable.

Cheers,

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Checkout our Reporting Solutions and our plugin shop at www.encuesta.biz .

The following user(s) said Thank You: charleyhankins
The topic has been locked.
More
5 years 1 month ago #123317 by charleyhankins
Thanks very much for your quick and informative reply.
The topic has been locked.
More
5 years 1 month ago #123318 by charleyhankins
We have more than one limesurvey db. Would you happen to know if there exists a method whereby I could import all of the old survey data into the new db?
The topic has been locked.
More
5 years 1 month ago #123320 by gabrieljenik
OK, So you want to merge...

Server by server, export all the surveys on lss format and import them back on the new server.
If they are not too many, than the the most practical solution.

If not, you could try with the usual SQL dump (only data option).
You would have to review the script for not oversteping IDs and only exporting survey info and not master data.
(That would be more tricky)

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Checkout our Reporting Solutions and our plugin shop at www.encuesta.biz .

The topic has been locked.
More
5 years 1 month ago #123337 by tpartner
Replied by tpartner on topic how to restore old data?
If exporting/importing the surveys, I suggest the survey archive (.lsa) format. It will include structure, data and token table.

manual.limesurvey.org/Exporting_a_survey...y_archive_.28.lsa.29

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Official LimeSurvey Partner - partnersurveys.com
The topic has been locked.

Start now!

Just create your account and start using Limesurvey today.

Register now