When having to migrate hugh numbers of IP addresses on Plesk, here is a way to manipulate the database to do it without having to use the panel to do them one at a time.
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
mysql> SELECT * FROM IP_Addresses;
mysql> UPDATE Repository SET component_id = [new ip id] WHERE component_id = [old ip id];
mysql> UPDATE hosting SET ip_address_id = [new ip id] WHERE ip_address_id = [old ip id];
Comments
Leave a comment Trackback