Migrating the PSM Database to a New Server
Use this procedure to migrate the PSM database to a new server.
Stop the PSM server.
psm-stop
The stop command successfully completes when the 'Ems-' processes all change to "Not monitored" state. Type <ctrl> c to exit the Linux watch command window.
Export the whole MySQL database from the source machine. At the shell prompt on the OS, run the following command:
mysqldump –u<user> –p --all-databases > dumpdb.sql
This command exports the entire MySQL database.
Alternatively, specify each PSM schema separately and take the backup file. For example, from the shell prompt on the OS, run the following command:
mysqldump -u<user> -p --databases ems emsquartz radius net_snmp hoard bti7xx_14 bti701_v107 bti7000_720 bti7000_920 bti2060_620 axn xxx.sql ... > dumpdb.sql
Copy the PSM database from the server to a temporary location.
Install the operating system on the new server.
Start MySQL.
service mysqld start
Import the PSM database from the temporary location.
mysql -u<user> -p < dumpdb.sql
Log in to MySQL.
mysql -u<user> -p
Flush the database settings. At the MySQL prompt, enter:
flush privileges;
Exit MySQL.
Install the PSM server.