<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On 30 March 2017 at 08:08, Saverio Proto <span dir="ltr"><<a href="mailto:saverio.proto@switch.ch" target="_blank">saverio.proto@switch.ch</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello,<br>
<br>
I am testing the neutron l2gw in our staging env.<br>
<br>
Because I cant redeploy everything, to retry the installation of the<br>
l2gw, to clean the database I drop the following tables from the neutron<br>
database:<br>
<br>
drop table physical_ports;<br>
drop table physical_locators;<br>
drop table physical_switches;<br>
drop table logical_switches;<br>
drop table ucast_macs_remotes;<br>
drop table ucast_macs_locals;<br>
drop table vlan_bindings;<br>
drop table pending_ucast_macs_remotes;<br>
drop table l2gatewayinterfaces;<br>
drop table l2gatewaydevices;<br>
drop table l2gatewayconnections;<br>
drop table l2gateways;<br>
drop table l2gw_alembic_version;<br>
<br>
I would strongly suggest to have a common prefix like l2gw_ for all the<br>
tables that belong to the same neutron plugin.<br>
<br>
How can I figure out if I missed a table without reading all the code ?<br></blockquote><div><br></div><div>There's no written rule to prefix tables with formal labels. IMO it would largely fail as a rule in practice even if we wrote one down. Have you considered taking a backup of your DB prior to the migration so that you can restore from it?</div><div><br></div><div>Thanks,</div><div>Armando</div><div><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
Thank you<br>
<br>
Saverio<br>
<br>
<br>
<br>
--<br>
SWITCH<br>
Saverio Proto, Peta Solutions<br>
Werdstrasse 2, P.O. Box, 8021 Zurich, Switzerland<br>
phone +41 44 268 15 15, direct +41 44 268 1573<br>
<a href="mailto:saverio.proto@switch.ch">saverio.proto@switch.ch</a>, <a href="http://www.switch.ch" rel="noreferrer" target="_blank">http://www.switch.ch</a><br>
<br>
<a href="http://www.switch.ch/stories" rel="noreferrer" target="_blank">http://www.switch.ch/stories</a><br>
<br>
______________________________<wbr>______________________________<wbr>______________<br>
OpenStack Development Mailing List (not for usage questions)<br>
Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" target="_blank">OpenStack-dev-request@lists.<wbr>openstack.org?subject:<wbr>unsubscribe</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" target="_blank">http://lists.openstack.org/<wbr>cgi-bin/mailman/listinfo/<wbr>openstack-dev</a><br>
</blockquote></div><br></div></div>