1.Use the dumped icehouse db schema
mysql -uroot -ppassw0rd neutron <neutron.sql
The schema of table `portbindingports` in neutron.sql
--
-- Table structure for table `portbindingports`
--
DROP TABLE IF EXISTS `portbindingports`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `portbindingports` (
`port_id` varchar(36) NOT NULL,
`host` varchar(255) NOT NULL,
PRIMARY KEY (`port_id`),
CONSTRAINT `portbindingports_ibfk_1` FOREIGN KEY (`port_id`) REFERENCES `ports` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `portbindingports`
--
LOCK TABLES `portbindingports` WRITE;
/*!40000 ALTER TABLE `portbindingports` DISABLE KEYS */;
INSERT INTO `portbindingports` VALUES ('ce00ddaa-af63-4fa8-9c17-79601719d0a3','zma-virtual-machine');
/*!40000 ALTER TABLE `portbindingports` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `portqueuemappings`
--
2. Upgrade neutron db from icehouse to kilo
#neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugins/vmware/nsx.ini upgrade head
1.Use the dumped icehouse db schema
mysql -uroot -ppassw0rd neutron <neutron.sql
The schema of table `portbindingports` in neutron.sql
--
-- Table structure for table `portbindingports`
--
DROP TABLE IF EXISTS `portbindingports`; set_client */; set_client = utf8 */; ts_ibfk_ 1` FOREIGN KEY (`port_id`) REFERENCES `ports` (`id`) ON DELETE CASCADE set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_
/*!40101 SET character_
CREATE TABLE `portbindingports` (
`port_id` varchar(36) NOT NULL,
`host` varchar(255) NOT NULL,
PRIMARY KEY (`port_id`),
CONSTRAINT `portbindingpor
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_
--
-- Dumping data for table `portbindingports`
--
LOCK TABLES `portbindingports` WRITE; af63-4fa8- 9c17-79601719d0 a3','zma- virtual- machine' );
/*!40000 ALTER TABLE `portbindingports` DISABLE KEYS */;
INSERT INTO `portbindingports` VALUES ('ce00ddaa-
/*!40000 ALTER TABLE `portbindingports` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `portqueuemappings`
--
2. Upgrade neutron db from icehouse to kilo neutron. conf --config-file /etc/neutron/ plugins/ vmware/ nsx.ini upgrade head
#neutron-db-manage --config-file /etc/neutron/