Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: General Backup question

General Backup question 2 years 9 months ago #67393

I have looked in the manual for this, but cannot find a reasonably detailed answer to the following questions.

1) If I do a nightly dump of the mysql DB, is there and easy way to restore the questionnaire?
2) If I export the full database via the Limesurvey feature, how can this be restored

Thanks
The administrator has disabled public write access.

Re: General Backup question 2 years 9 months ago #67396

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6205
  • Thank you received: 787
  • Karma: 238
You can purge all database and reimport it via phpmyadmin for example if you are on mysql.

It's like all database system: purge, reimport
The administrator has disabled public write access.

Re: General Backup question 2 years 9 months ago #67403

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5300
  • Thank you received: 291
  • Karma: 247
There are no inbuild functions at Limesurvey to import such a backup, but all database systems can import the generated .sql files.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

Re: General Backup question 2 years 9 months ago #67410

I just thought that given that there is the builtin funtionality of doing a full database export (great feature) there would be a built in feature the import the database (or a particular survey including the responses
The administrator has disabled public write access.

Re: General Backup question 2 years 9 months ago #67411

yes, thanks for the suggestions, but isn't there more to this? What about the web side of things. I'm talking about a system failure where I need to restore the Survey.

I guess the answer is that I need to restore both the web directories + the DB
The administrator has disabled public write access.

Re: General Backup question 2 years 9 months ago #67412

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5300
  • Thank you received: 291
  • Karma: 247
All survey data is stored at the database. So if something breaks and you have a DB backup, all is fine.
Of course, when modifying the core files you should always create backups, but those files are only touched when updating to a newer version (while data is usually not touched during update).

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

Re: General Backup question 2 years 9 months ago #67415

Thanks, but am still not entirely clear how this will work. Maybe an example will clarify this.

Let's start with a Survey called Survey-A. I'm backing the database up every night and after two weeks I decide to try and restore Survey-A at another site to ensure the backups work. If I have Limesurvey already running at the other site, what would be the steps to restore Survey-A at the new site (assuming the core files are the same. Will restoring the DB be the only thing I have to do?

Thanks
The administrator has disabled public write access.

Re: General Backup question 2 years 9 months ago #67426

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5300
  • Thank you received: 291
  • Karma: 247
At the test system you can simply import the database backup and then change config.php database settings so that the test system grabs the data from the newly imported database for testing.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

Re: General Backup question 2 years 9 months ago #67481

I'm clearly missing something here. I'm running V1.91 on Linux with mysql and Apache.

So far I have

1) a brand new web environment, create empty db with user and correct access rights, import the export via Mysql Administrator to the schema I just created. Result is that I get an "Unable to connect" error in Firefox

2) a brand new web environment, create empty db with user and correct access rights. Run the install script and then import the export via Mysql Administrator to the same schema I created during this step. Result is that I get an "Unable to connect" error in Firefox

Thanks
The administrator has disabled public write access.

Re: General Backup question 2 years 9 months ago #67489

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5300
  • Thank you received: 291
  • Karma: 247
At the exported DB, what did you use as:
a) database name
b) database prefix

Please also post your DB settings from config.php.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Moderators: ITEd
Time to create page: 0.117 seconds
Donation Image