Check out the LimeSurvey source code on GitHub!

Database of Limesurvey accidentally dropped. how to recover?

More
4 years 11 months ago #75943 by guardianecho
Good Day!

I've been working with Limesurvey for a few weeks now.

i just encountered a very big problem today.

while i was cleaning the tokens in PHPmyAdmin using the 'drop' function. it dropped the whole database of phpsurveyor.

and now i cant access our limesurvey ~_~
120.28.14.244/limesurvey/admin/admin.php
it says 'The LimeSurvey database does not exist. Please run the install script to create the necessary database.'

how can i restore the database? anyone please help :'( thanks very much!

Please Log in to join the conversation.

More
4 years 11 months ago #75963 by DenisChenu

guardianecho wrote: how can i restore the database? anyone please help :'( thanks very much!

Hello,

Did you have a auto backup system ?

Without backup, i don't see how to resolve this issue ....

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Please Log in to join the conversation.

More
4 years 11 months ago #76007 by guardianecho
they dont have back up. though we re installed it so everything is back to normal now. though the tokens and survey questions are now lost T_t thanks for the reply! :]

Please Log in to join the conversation.

More
4 years 11 months ago - 4 years 11 months ago #76017 by c_schmitz
Mental note: Always do a database backup first before you start fiddling with the database ;)

Best regards

Carsten Schmitz
LimeSurvey project leader
Last Edit: 4 years 11 months ago by c_schmitz.

Please Log in to join the conversation.

More
4 years 11 months ago - 4 years 11 months ago #76026 by DenisChenu

c_schmitz wrote: Mental note: Always do a database backup first before you start fiddling with the database ;)

Mental note2: Allways put an "Automatic dump & backup script" at your crontab.

It's the first thing i do after a server installation:
1st : backup all script
2nd : filter what i backup

;)

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
Last Edit: 4 years 11 months ago by DenisChenu.

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form