topic Restore Controller Database in Splunk AppDynamics

Restore Controller Database

手塚_隆之 — Fri, 16 Mar 2018 01:35:02 GMT

I want to restore the controller's database from metadata backup(level2) to new enviroment.

New environmet have same hostname and ip address and version.(Ver4.4.2)

The document states that using the user "controller @ localhost" to import the data,
but I do not set the password for the user "controller@localhost" when installing.

It was possible to restore using user "root @ localhost".

What is the password for user "controller @ localhost"?

As I did, is the restore correct using the user "root @ localhost"?

>$install/db/bin/mysql -u controller -p<ControllerDBpassword> controller < metadata_dump.sql
https://docs.appdynamics.com/display/PRO44/Controller+Data+Backup+and+Restore

Re: Restore Controller Database

Pratik_Maskey — Mon, 26 Mar 2018 10:25:23 GMT

You can use the same "root" user through which you took the dump or you can use "controller" user with default password as "controller"(<ControllerDBpassword>).

Thanks

Re: Restore Controller Database

手塚_隆之 — Tue, 27 Mar 2018 00:11:43 GMT

pratik.maskey

Thank you for your replay.

I understood!