There are times when you may need to migrate many IP addresses in Plesk. You could either do this by hand, one domain at a time or you can modify the database by hand which will save countless years of your life.

I will assume you have logged into mysql and have selected the psa database. After logging in, get a listing of IP addresses. Make sure that you have read the new IP addresses into Plesk by first logging into the control panel and performing a "Reread IP".

mysql> SELECT * FROM IP_Addresses;

You will see a list of id numbers in the first column followed by the addresses in the second column. Perform the modification of the component_id table.

mysql> UPDATE Repository SET component_id = <new id> WHERE component_id = <old id>;

Then update the hosting table.

mysql> UPDATE hosting SET ip_address_id = <new id> WHERE ip_address_id = <old id>;

Finally, update the forwarding table if necessary.

mysql> UPDATE forwarding SET ip_address_id = <new id> WHERE ip_address_id = <old id>;

Once this is done, check the IP section in Plesk and everything should be moved.