Welcome, Guest
Username: Password:

TOPIC: Database of Limesurvey accidentally dropped. how to recover?

Database of Limesurvey accidentally dropped. how to recover? 4 years 1 month ago #75943

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!
The administrator has disabled public write access.

Database of Limesurvey accidentally dropped. how to recover? 4 years 1 month ago #75963

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 8718
  • Thank you received: 1214
  • Karma: 360
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 ....
The administrator has disabled public write access.

Database of Limesurvey accidentally dropped. how to recover? 4 years 1 month ago #76007

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! :]
The administrator has disabled public write access.

Database of Limesurvey accidentally dropped. how to recover? 4 years 1 month ago #76017

  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 975
  • Thank you received: 133
  • Karma: 97
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 1 month ago by c_schmitz.
The administrator has disabled public write access.

Database of Limesurvey accidentally dropped. how to recover? 4 years 1 month ago #76026

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 8718
  • Thank you received: 1214
  • Karma: 360
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
Last Edit: 4 years 1 month ago by DenisChenu.
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 1.415 seconds