Welcome, Guest
Username: Password: Remember me

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

Database of Limesurvey accidentally dropped. how to recover? 2 years 4 months 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.

Re: Database of Limesurvey accidentally dropped. how to recover? 2 years 4 months ago #75963

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6207
  • Thank you received: 788
  • Karma: 238
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.

Re: Database of Limesurvey accidentally dropped. how to recover? 2 years 4 months 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.

Re: Database of Limesurvey accidentally dropped. how to recover? 2 years 4 months ago #76017

  • c_schmitz
  • c_schmitz's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 744
  • Thank you received: 99
  • Karma: 87
Mental note: Always do a database backup first before you start fiddling with the database ;)
Support us, too. Donate to the LimeSurvey project and help keep us going!
Last Edit: 2 years 4 months ago by c_schmitz.
The administrator has disabled public write access.

Re: Database of Limesurvey accidentally dropped. how to recover? 2 years 4 months ago #76026

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6207
  • Thank you received: 788
  • Karma: 238
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: 2 years 4 months ago by DenisChenu.
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.114 seconds
Donation Image