Change ERPNext database

ERPNext
1

I have taken a copy of an instance running ERPNext so that I can experimentally run an upgrade on it.

I want to change the database host and database name so that I can do this without affecting my master instance.

I am thinking I should change the options in the common_site_config.json file.

After I do this I should issue bench restart

Does anyone think this is wrong or there is some different way to do this?

Thanks.

2

You could also use a mysqldump of the erpnext database

mysqldump -uroot -p -b DATABASE_NAME > DBdumpFileName.sql

and keep that on a different/safe location so that you can restore it if required