Welcome to the LimeSurvey Community Forum

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

Change database location

  • ch123
  • ch123's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
3 years 3 months ago #221788 by ch123
Change database location was created by ch123
Hello all!

We have Limesurvey running on our university's servers. Unfortunately, the database running Limesurvey has to be moved to another host. However, the name of the database, access data, etc. do not change. 
I would like to ask what I have to consider and what effects this might have on the running surveys. 

Is there a way to change the database in Limesurvey? In the config.php file I found this excerpt:

'connectionString' => 'mysql:host=XXXXXX;

Here I probably have to change the XXXXXX to the new host, right? Is that enough or do I have to adjust it elsewhere?
According to our university, the data from the old database should also be transferred to the new database. Does Limesurvey then automatically recognize that it just continues to work in the corresponding tables?
Or do I have to consider something regarding the current surveys?

Of course I would also backup the entire database beforehand. In case of an emergency, is it possible to simply insert it into the new database or is that complicated?

Or would you not recommend to make this change in running projects?

Unfortunately I am not familiar with these server/database settings .... Thanks for any help!!!
The topic has been locked.
  • ch123
  • ch123's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
3 years 2 months ago #222907 by ch123
Replied by ch123 on topic Change database location
Someone can help me with this? It's still not solved... 
thank you :)
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team & Official Partner
  • LimeSurvey Community Team & Official Partner
More
3 years 2 months ago #222914 by DenisChenu
Replied by DenisChenu on topic Change database location
> Here I probably have to change the XXXXXX to the new host, right? Is that enough or do I have to adjust it elsewhere?
> According to our university, the data from the old database should also be transferred to the new database. Does Limesurvey then automatically recognize that it just continues to work in the corresponding tables?

Yes and yes. If databqe is the same : yes on both questions.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
Moderators: holchtpartner

Lime-years ahead

Online-surveys for every purse and purpose