Bienvenue, Invité
Nom d'utilisateur : Mot de passe : Se souvenir de moi

SUJET : Manual method for moving survey to another database

Manual method for moving survey to another database il y a 5 mois 3 jours #101610

  • Mike1985_2
  • Portrait de Mike1985_2
  • Hors ligne
  • Fresh Lemon
  • Messages : 2
  • Karma: 0
I have LimeSurvey 1.90 installed on two servers and I want to be able to copy a survey from one to the other without using the admin system to import or export.

How risky is it and what table do I need to consider??

Obviously I will need to copy `survey_xxxxx`, `tokens_xxxxx`, a row from `surveys` and a row from `surveys_languagesettings`. I suppose I will have to copy over the `conditions`, `questions` and `answers` as well. (Sorry I'm basically answering my on question here).

Will indexing and id's become an issue?
L'administrateur a désactivé l'accès en écriture pour le public.

Manual method for moving survey to another database il y a 5 mois 3 jours #101612

  • Ben_V
  • Portrait de Ben_V
  • Hors ligne
  • Platinum Lime
  • Messages : 933
  • Remerciements reçus 193
  • Karma: 62
Is your 2nd installation (for import) new?
...without using the admin system to import or export.
Pure curiosity: Why not?
Benoît

goo.gl/Bw5iM => Recherche GG dans le forum français (remplacer "exemple" dans la barre de recherche)
goo.gl/WX8PH => GG search for english forum (Replace "example" in the search bar)
goo.gl/IxiGu => Búsqueda en el foro en español (Cambiar "ejemplo" en la barra de...
Dernière édition: il y a 5 mois 3 jours par Ben_V.
L'administrateur a désactivé l'accès en écriture pour le public.

Manual method for moving survey to another database il y a 5 mois 3 jours #101615

  • Mike1985_2
  • Portrait de Mike1985_2
  • Hors ligne
  • Fresh Lemon
  • Messages : 2
  • Karma: 0
Nothing more than inter-office politics! It's as sad as that.

They're both at 1.90 and are both already installed. It's looking like every single table needs partially copying here.

How about this.. Can I export the survey (using the admin system or whatever) as SQL? Just one time so I can unpick it and understand and consider everything that is needed? At the moment, the export is an XML file which I don't really understand..
L'administrateur a désactivé l'accès en écriture pour le public.

Manual method for moving survey to another database il y a 5 mois 3 jours #101616

  • Ben_V
  • Portrait de Ben_V
  • Hors ligne
  • Platinum Lime
  • Messages : 933
  • Remerciements reçus 193
  • Karma: 62
Theoretically you can update a database using PhpMyAdmin or similar interface...
In your case it sounds that you will get lots of trouble with groups & question IDs...
Note that you can change (everywhere) without problem the survey ID directly in your (xml) export/import file.

I hope another LS user may give you some good advices, because I can't personnaly encourage you to apply this process :(
Benoît

goo.gl/Bw5iM => Recherche GG dans le forum français (remplacer "exemple" dans la barre de recherche)
goo.gl/WX8PH => GG search for english forum (Replace "example" in the search bar)
goo.gl/IxiGu => Búsqueda en el foro en español (Cambiar "ejemplo" en la barra de...
L'administrateur a désactivé l'accès en écriture pour le public.

Manual method for moving survey to another database il y a 5 mois 3 jours #101621

  • c_schmitz
  • Portrait de c_schmitz
  • Hors ligne
  • LimeSurvey Team
  • Messages : 719
  • Remerciements reçus 91
  • Karma: 83
TBH I don't see a viable solution here.
Support us, too. Donate to the LimeSurvey project and help keep us going!
L'administrateur a désactivé l'accès en écriture pour le public.
Modérateurs: ITEd
Temps de génération de la page : 0.126 secondes
Donation Image