Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

how to restore old data?

  • charleyhankins
  • charleyhankins's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 3 months ago #123315 by charleyhankins
how to restore old data? was created 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.
  • gabrieljenik
  • gabrieljenik's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
9 years 3 months ago #123316 by gabrieljenik
Replied by gabrieljenik on topic how to restore old data?
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.
  • charleyhankins
  • charleyhankins's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 3 months ago #123317 by charleyhankins
Replied by charleyhankins on topic how to restore old data?
Thanks very much for your quick and informative reply.
The topic has been locked.
  • charleyhankins
  • charleyhankins's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 3 months ago #123318 by charleyhankins
Replied by charleyhankins on topic how to restore old data?
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.
  • gabrieljenik
  • gabrieljenik's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
9 years 3 months ago #123320 by gabrieljenik
Replied by gabrieljenik on topic how to restore old data?
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.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 3 months 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.

www.limesurvey.org/manual/Exporting_a_su...y_archive_.28.lsa.29

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose