SteelCentral™ Enterprise NetProfiler Software Installation Guide
31
Upgrading
rm –rf /mnt/data/migration
Import Data in to the MySQL Database
After you imported the user configuration and historical data, you can import data in to the MySQL database.
Follow these steps
:
1.
On the existing appliance, stop all ‘mazu’ services on the existing appliance. Execute this command:
sudo service mazuctl stopall
2.
Navigate to the following directory:
/etc/my.cnf.d/
3.
Open the server.conf file and remove the following line:
bind-address=127.0.0.1
4.
Log into the MySQL server, and execute the following command to create a specific restore account:
CREATE USER 'mazu'@'<dst host IP>' IDENTIFIED BY 'restore';
GRANT ALL ON *.* TO 'mazu'@'<dst host IP>';
FLUSH PRIVILEGES;
5.
Restart the MySQL server services. Execute the following command:
sudo service mysql restart
sudo services ipables stop
6.
On the new appliance, execute the following command from a command line window:
for db in DB_cbqos DB_configuration DB_eifcip2ipnf DB_eifcnf DB_metadata DB_mygroups
DB_registry DB_wta_definitions master_list; do echo "Loading $db"; mysqldump -h <Src host IP>
--port 3306 -u mazu –p'restore' $db --compress | mysql -A -D $db; done
Wait until the database restore is complete.
7.
Verify that the data was successfully restored, by examining the database tables. For example:
mysql -A -e "select grp_id,grp_name,description from DB_mygroups.DB_host_groups;"
You have successfully migrated your environment to a xx80 appliance.
