Change database location

More
6 months 2 weeks ago #221788 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!!!

Please Log in to join the conversation.

More
5 months 2 weeks 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 :)

Please Log in to join the conversation.

More
5 months 2 weeks 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 service on demand , plugin development .
I don't answer to private message.

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now