KBEA-00142 - Backing up or moving the Cluster Manager database

Summary

This article discusses how to backup and move the Cluster Manager (CM) database.

Solution

The preferred method to back up the CM database is to use the cmtool command.

Backing Up the Database

Example running cmtool from the CM machine:

cmtool login  
cmtool exportData 

Example running cmtool from a different machine with eMake installed:

cmtool --cm= login  
cmtool --cm= exportData 

Importing a Database

Example running cmtool from the CM:

cmtool login  
cmtool importData 

Example running cmtool from a different machine with eMake installed:

cmtool --cm= login  
cmtool --cm= importData 

Previously Documented Method

Note: Although the ecbackupdb.bat script is still available on the CM, it has been deprecated so it may or may not work.

1. On the CM machine that contains the database you want to back up, run ecbackupdb.bat

This creates c:\eccm_full_dump.sql or /tmp/eccm_full_dump.sql

1. Copy eccm_full_dump.sql to the new CM machine.

2. Perform the following on the new CM:

   cd  c:\ECloud\i686_Win32\mysql\bin or /opt/ecloud/i686_Linux/mysql/bin

3. Then type:

   mysql ecloud < eccm_full_dump.sql

4. OS versions: All