Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

LimeSurvey ver 3.25.4 to new version of my surveys

  • gokhandincel
  • gokhandincel's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 1 month ago #241764 by gokhandincel
Please help us help you and fill where relevant:
Your LimeSurvey version: LimeSurvey version3.25.4

i want to upload all my surveys to my new limesurvey domain. i dumpted all database and import to new but it didnt work. can you a link which describes it. thanks. 

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 year 1 month ago #241776 by holch
What do you mean with "you dumped all database and import to new"?

And what is the new version?

First of all, setup the new database with the old database dump. Then install the new Limesurvey installation using this copy of the old database.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The following user(s) said Thank You: gokhandincel

Please Log in to join the conversation.

  • gokhandincel
  • gokhandincel's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 1 month ago #241780 by gokhandincel
Replied by gokhandincel on topic LimeSurvey ver 3.25.4 to new version of my surveys
i mean i installed new version(5.6.11) and i exported old db from 3.25.4 and imported to new 5.6.11 buy i have errors. if i do wrong can you recommend an link which explains what i should do. is there a problem for import db from 3 to 5?

Please Log in to join the conversation.

  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 year 1 month ago #241786 by tpartner
There are database differences. You will need to follow the normal upgrading process - manual.limesurvey.org/Upgrading_from_a_previous_version/en

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The following user(s) said Thank You: gokhandincel

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 year 1 month ago #241789 by holch

i mean i installed new version(5.6.11)


You shouldn't have. At least not if you wanted to use the old database as a base. Either you just update the current installation from LS3 to LS5, or you make a copy of the database from LS3 and use this as a base to install LS5 into. As I said above.

and i exported old db from 3.25.4 and imported to new 5.6.11

How did you do that?

buy i have errors.

I am not suprised... ;-)

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

Please Log in to join the conversation.

  • gokhandincel
  • gokhandincel's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 1 month ago #241790 by gokhandincel
Replied by gokhandincel on topic LimeSurvey ver 3.25.4 to new version of my surveys
i imported with phpmyadmin. thanks to "Tony Partner(@tpartner)" i will try

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 year 1 month ago #241791 by holch
Import the copy of the old database BEFORE you install the new version and use the copy of the old database to install the new version. It should work out fine. But Tpartners link should it explain it pretty well.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The following user(s) said Thank You: DenisChenu

Please Log in to join the conversation.

  • gokhandincel
  • gokhandincel's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 3 weeks ago - 1 year 3 weeks ago #241937 by gokhandincel
Replied by gokhandincel on topic LimeSurvey ver 3.25.4 to new version of my surveys
i made all of things i installed last version Sürüm 5.6.11+230320  i can create survey etc. my database updated to 495 too  but when i try to export database with phpmyadmin it cant export but it doesnt give any errors too. just dont do.i can import and i can create database backup with mysqldump command. i could import it again and there arent any problem. but i could have exported database with phpmyadmin at 3.25 version. should i do something about that. 

ps:i can backup and dump at navicat too . but phpmyadmin cant do that.
Last edit: 1 year 3 weeks ago by gokhandincel.

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 year 3 weeks ago - 1 year 3 weeks ago #241938 by holch
Sorry, I don't understand what you are doing.

To use your surveys from your old LS3 installation in a new LS 5 installation you need to do the following steps:

1. Export a copy of the limesurvey database from LS 3.

2. create a new database based on this copy

3. Install LS5

4. When asked for the database, use the one you have created from a copy of LS3

Afaik you can't import a different database into a Limesurvey installation that has already been installed with a database.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

Last edit: 1 year 3 weeks ago by holch.

Please Log in to join the conversation.

  • gokhandincel
  • gokhandincel's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 3 weeks ago - 1 year 3 weeks ago #241939 by gokhandincel
Replied by gokhandincel on topic LimeSurvey ver 3.25.4 to new version of my surveys
1-) new server i installed 3 and i import database of 3(old database)
2-)i copy paste of files just like at link explaination.
there arent any problem.

but i cant export database from 5 with phpmyadmin but ican do that command line with mysqldump command and i can do that with navicat which is a database program.

i am asking why cant i do with 5. i could have export with 3

is it clear ?

ps : ohh is that mean i should install old database of 3 after i installed (copy paste) 5 version ?
Last edit: 1 year 3 weeks ago by gokhandincel.

Please Log in to join the conversation.

  • gokhandincel
  • gokhandincel's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 3 weeks ago #241941 by gokhandincel
Replied by gokhandincel on topic LimeSurvey ver 3.25.4 to new version of my surveys
when i installed 3 and copy paste files of 5 then i imported of database of 3 then i get this error at when i updated database:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'lim_permissiontemplates' already exists

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 year 3 weeks ago #241942 by holch
Sorry, I don't understand what you are doing. You are jumping around from here to there.

It is not clear to me what your problem is and which steps you are doing.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

Please Log in to join the conversation.

Lime-years ahead

Online-surveys for every purse and purpose