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

TOPIC: General Backup question

General Backup question 4 years 3 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.

General Backup question 4 years 3 months ago #67396

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 8249
  • Thank you received: 1125
  • Karma: 335
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.

General Backup question 4 years 3 months ago #67403

  • Mazi
  • Mazi's Avatar
  • Online
  • LimeSurvey Team
  • Posts: 5843
  • Thank you received: 348
  • Karma: 261
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.

General Backup question 4 years 3 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.

General Backup question 4 years 3 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.

General Backup question 4 years 3 months ago #67412

  • Mazi
  • Mazi's Avatar
  • Online
  • LimeSurvey Team
  • Posts: 5843
  • Thank you received: 348
  • Karma: 261
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.

General Backup question 4 years 3 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.

General Backup question 4 years 3 months ago #67426

  • Mazi
  • Mazi's Avatar
  • Online
  • LimeSurvey Team
  • Posts: 5843
  • Thank you received: 348
  • Karma: 261
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.

General Backup question 4 years 3 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.

General Backup question 4 years 3 months ago #67489

  • Mazi
  • Mazi's Avatar
  • Online
  • LimeSurvey Team
  • Posts: 5843
  • Thank you received: 348
  • Karma: 261
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.

General Backup question 4 years 3 months ago #67550

File Attachment:

File Name: config.php.txt
File Size:4 KB

I've exported/dumped the DB as follows:

1) Via the Full DB export in LimeSurvey
2) via the standard mysql dump

Results for both are the same.

When I import, I've tried a new schema or using an existing schema, I've successfully connected via the command line using the credentials in the attached config.php

Set debug to 1, but that doesn't seem to log to any of the obvious places.


Thanks
Last Edit: 4 years 3 months ago by c_schmitz.
The administrator has disabled public write access.

General Backup question 4 years 3 months ago #67558

  • Mazi
  • Mazi's Avatar
  • Online
  • LimeSurvey Team
  • Posts: 5843
  • Thank you received: 348
  • Karma: 261
No attachment :-(

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.

General Backup question 4 years 3 months ago #67573

Sorry, with time difference I'm not at work anymore

BTW, I don't think the upload accepts php file, so renamed it to .txt file and then edited the message. Not sure if that's the problem.

Will paste the whole file in the message.
Cheers
The administrator has disabled public write access.

General Backup question 4 years 3 months ago #67586

  • Mazi
  • Mazi's Avatar
  • Online
  • LimeSurvey Team
  • Posts: 5843
  • Thank you received: 348
  • Karma: 261
You are right, .php files are not allowed (for security reasons).
Simply copy-paste those settings.

In general the settings should match at both systems, otherwise the system will be looking at the wriong DB/tables.

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.

General Backup question 4 years 3 months ago #67661

As usual, the problem is in the chair:-)

I had the wrong database in the config file

I've now connected to the restored DB, but cannot see the Survey.

After dropping the schema and re-importing the full database dump generated from within Limesurvey I now get the message that
The LimeSurvey database does exist but it seems to be empty. Please run the install script to create the necessary tables.


So decided to start from scratch

1) Installed new instance : OK
2) Imported full dump exported from Limesurvey : OK
3) Cannot see the survey as the full export only contains the attached; no survey table as far as I can see; everything is prefixed by v1_


Last Edit: 4 years 3 months ago by lister171254. Reason: more info
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Moderators: ITEd
Time to create page: 0.168 seconds