How to migrate IP addresses from IPmanager 6?

The Integration with IPmanager 6 module is used to combine DCImanager 6 and VMmanager 6 address spaces. The module combines records about physical networks, pools, and blocks of IP addresses, but it does not transfer information about IP address relationships to dedicated servers and virtual machines (VMs). This article describes how to migrate IP address information to the platform that acts as a master during integration.

Note

IP migration should be performed to a "clean" platform — without created VMs or added servers.

To migrate IP address information:

Install and configure the Integration with IPmanager 6 module according to the instructions in the VMmanager 6 or DCImanager 6 documentation.
On the source server:
1. Connect to the server via SSH.
2. Create a database dump file:
```
docker exec -it mysql bash -c "mysqldump <database> -p\$MYSQL_ROOT_PASSWORD ip ipnet ippool ippool_range userspace >/root/ipmgr.sql"
```
  Comments to the command
  <database> — database name, depending on the platform type:
  - VMmanager 6 — isp
  - DCImanager 6 — dci_1
3. Copy the dump file to the /root directory:
```
docker cp mysql:/root/ipmgr.sql /root/
```
Copy the dump file /root/ipmgr.sql to the master server into the /root directory.
On the master server:
1. Подключитесь к серверу по SSH.
2. Import the data from the dump file:
```
docker cp /root/ipmgr.sql mysql:/root/
```
```
docker exec -it mysql bash -c "mysql <database> -p\$MYSQL_ROOT_PASSWORD"
```
  Comments to the command
  <database> — database name, depending on the platform type:
  - VMmanager — isp
  - DCImanager — dci_1
```
source /root/ipmgr.sql;
```
3. To ensure that IP addresses, networks and pools appear correctly in the interfaces of both platforms, move them to the public address space:
  1. Define the id of the public space:
```
select id from userspace where is_public=1;
```
    Example of reply
```
+----+
| id |
+----+
|  1 |
+----+
```
  2. Move the objects to the public space:
```
update ip set userspace=<public_id>;
```
```
update ippool set userspace=<public_id>;
```
```
update ipnet set userspace=<public_id>;
```
    Comments to the command
    <public_id> — id of the public address space