Configuring RTM table partition backups
The following procedure applies when you use the RTM partitioning scheme. Complete these steps before you run RTM database maintenance.
- Upgrade to an RTM version that supports partition backups.
Configure backup partitions under Enable Record Partitioning and configure Backup Table Partitions as shown in Figure 1.. Select
- Before you migrate, make sure that at least one day has passed.
- After one day, locate the files in /opt/IBM/cacti/backup/partition_backups.
- Transfer the files to the new server. Run the following command on the new server:
cd /opt/IBM/cacti/plugins/grid php -q database_restore_partitions.phpNote: This process restores all the legacy data to the new RTM database. Again, try to complete this process before the RTM database maintenance takes place.