DB restoration from one environment to another environment.

[kundan1986]

Dear Experts,

I want to take the DB dumps from QA environment and restore it into DEV environment, we are using the the mySQL DB. Kindly mentioned all the steps that i need to perform. Also mentioned the steps that is required post db restoration in hybris.

Thanks,

[rohit31_raj92]

Not all but i can collect and mentioned few steps: Once you have created the db dump, then

https://blog.winhost.com/using-mysqldump-to-backup-and-restore-your-mysql-databasetables/

You will need to delete the sensitive data if any which you need not want to copy from QA to DEV

Change the solr urls if those are environment specific else when you do indexing on dev, it will impact QA server.

Note: You can use vm also.

[arvind-kumar_avinash · Accepted solution]

There are no additional steps required after you have restored the data; but just make sure you point to the correct database name in the local.properties file and restart the Hybris server. Follow https://stackoverflow.com/questions/105776/how-do-i-restore-a-dump-file-from-mysqldump for the process of restoring the data from the dump.

[kundan1986]

Thanks for the support, was able to connect with new DB dump

[arvind-kumar_avinash]

You are most welcome.