<div class="gmail_quote">On Thu, Nov 15, 2012 at 12:59 PM, Alan Johnson <span dir="ltr"><<a href="mailto:alan@datdec.com" target="_blank">alan@datdec.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im">Be sure to read my other post before running with this as it may be a dead end, but here is the dump from last night's backup (just the one row):</div>
<div><br></div><div><div><span style="font-family:'courier new',monospace">INSERT INTO vds_interface(addr, bond_name, bond_type, gateway, id, is_bond, bond_opts, mac_addr, name, network_name, speed, subnet, boot_protocol, type, VDS_ID, vlan_id, mtu, bridged)</span></div>
</div><div>
<div><font face="courier new, monospace"> VALUES(v_addr, v_bond_name, v_bond_type, v_gateway, v_id, v_is_bond, v_bond_opts, v_mac_addr, v_name, v_network_name, v_speed, v_subnet, v_boot_protocol, v_type, v_vds_id, v_vlan_id, v_mtu, v_bridged);</font></div>
<div><font face="courier new, monospace">END; $$;</font></div></div><div></div></blockquote></div><br><div>Whoops! I didn't actually read the SQL before sending, just skimmed looking for anything sensitive I see now that this is not at all useful. Here is a CSV output of that table:</div>
<div><br></div><div><pre>"id","name","network_name","vds_id","mac_addr","is_bond","bond_name","bond_type","bond_opts","vlan_id","speed","addr","subnet","gateway","boot_protocol","type","_create_date","_update_date","mtu","bridged"
"d9843c29-ff18-4f26-ba9c-19c24a3dc65d","bond0","","88089a7c-124e-11e2-877b-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-09 16:25:13.441602-04","2012-11-14 15:11:13.867575-05","1500","0"
"41e44be1-1e6a-4468-b613-0defc957e57a","bond1","","88089a7c-124e-11e2-877b-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-09 16:25:13.444754-04","2012-11-14 15:11:13.871171-05","1500","0"
"4aac622e-942b-424d-b37c-c9cac9c3eaa9","bond2","","88089a7c-124e-11e2-877b-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-09 16:25:13.447615-04","2012-11-14 15:11:13.874052-05","1500","0"
"2f3edf8c-60e6-4b0e-9a77-fd15f395ad2c","em1","ovirtmgmt","88089a7c-124e-11e2-877b-52540021f621","84:8f:69:75:50:e9","","","","","","1000","192.168.119.158","255.255.255.0","192.168.119.110","1","2","2012-10-09 16:25:13.421371-04","2012-11-14 15:11:13.876869-05","1500","1"
"59c2ce88-2f1e-4342-98f6-6e4c0fdcc60a","bond0","","acb1a7d6-122d-11e2-9f25-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-09 12:36:20.430133-04","2012-11-14 15:11:18.753809-05","1500","0"
"8f185782-29c7-4bea-95ef-ab02306bb7a1","bond1","","acb1a7d6-122d-11e2-9f25-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-09 12:36:20.43354-04","2012-11-14 15:11:18.75761-05","1500","0"
"3eaa26a9-10d0-4e8f-aab8-a02b7e5cb33b","bond2","","acb1a7d6-122d-11e2-9f25-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-09 12:36:20.43681-04","2012-11-14 15:11:18.761024-05","1500","0"
"2d931dfa-9b57-4342-8c1d-feb122bb908f","em2","","88089a7c-124e-11e2-877b-52540021f621","84:8f:69:75:50:eb","","","","","","1000","10.10.5.102","255.255.255.0","","","0","2012-10-09 16:25:13.429715-04","2012-11-14 15:11:13.879592-05","9000","0"
"53dcddb6-4494-4f8e-8b5c-ad139ceb551b","em1","ovirtmgmt","acb1a7d6-122d-11e2-9f25-52540021f621","84:8f:69:75:50:8e","","","","","","1000","192.168.119.186","255.255.255.0","192.168.119.110","1","2","2012-10-09 12:36:20.414512-04","2012-11-14 15:11:18.764122-05","1500","1"
"37d0d8d7-d512-4a74-99c2-e61fe82b893e","em2","","acb1a7d6-122d-11e2-9f25-52540021f621","84:8f:69:75:50:90","","","","","","1000","10.10.5.103","255.255.255.0","","","0","2012-10-09 12:36:20.419835-04","2012-11-14 15:11:18.770674-05","9000","0"
"a31eb4bc-dc2c-4697-8d72-e61e41fc2bdb","bond2","","ec7b4186-2e95-11e2-abe4-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-11-14 15:06:01.669305-05","2012-11-14 16:01:05.967822-05","1500","0"
"c8d832d2-e789-46de-a5b5-9d4bbbdada72","em1","ovirtmgmt","ec7b4186-2e95-11e2-abe4-52540021f621","84:8f:69:75:50:81","","","","","","1000","192.168.119.156","255.255.255.0","192.168.119.110","1","2","2012-11-14 15:06:01.648564-05","2012-11-14 16:01:05.969595-05","1500","1"
"bc5892b9-6b96-4034-b828-9d46b1c38060","em2","","ec7b4186-2e95-11e2-abe4-52540021f621","84:8f:69:75:50:83","","","","","","1000","10.10.5.101","255.255.255.0","","","0","2012-11-14 15:06:01.654161-05","2012-11-14 16:01:05.971152-05","9000","0"
"bfe14fb3-2040-4ece-bd99-51fe31eabfc4","bond4","","ec7b4186-2e95-11e2-abe4-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-11-14 15:06:01.657521-05","2012-11-14 16:01:05.972706-05","1500","0"
"7d544efc-9942-4596-990a-9e6841d592d1","bond3","","ec7b4186-2e95-11e2-abe4-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-11-14 15:06:01.660389-05","2012-11-14 16:01:05.974151-05","1500","0"
"238cbbc3-b1e0-404e-bf1d-e1ab95eed352","bond0","","ec7b4186-2e95-11e2-abe4-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-11-14 15:06:01.663768-05","2012-11-14 16:01:05.975702-05","1500","0"
"8c081d29-86a0-46e7-8bf9-89c7c17bf24b","bond1","","ec7b4186-2e95-11e2-abe4-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-11-14 15:06:01.666703-05","2012-11-14 16:01:05.977166-05","1500","0"
"f88cfbee-1468-4e53-8fd8-7285ff46dede","bond4","","88089a7c-124e-11e2-877b-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-09 16:25:13.434369-04","2012-11-14 15:11:13.885784-05","1500","0"
"369b0757-078a-4b18-b0de-d42cca1bcbad","bond3","","88089a7c-124e-11e2-877b-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-09 16:25:13.438335-04","2012-11-14 15:11:13.888115-05","1500","0"
"42825d0d-acb0-46e0-b84d-aee4cdee3f55","em1","ovirtmgmt","e5a52b3c-0f10-11e2-94c2-52540021f621","84:8f:69:75:50:f6","","","","","","1000","192.168.119.188","255.255.255.0","192.168.119.110","1","2","2012-10-05 13:25:47.081134-04","2012-11-14 15:11:15.811989-05","1500","1"
"774504e6-ad28-419f-84ba-b5d138462472","em2","","e5a52b3c-0f10-11e2-94c2-52540021f621","84:8f:69:75:50:f8","","","","","","1000","10.10.5.104","255.255.255.0","","","0","2012-10-05 13:25:47.089057-04","2012-11-14 15:11:15.817492-05","9000","0"
"bfe6b177-dd9f-4a93-a362-fcb179b9b11b","bond4","","e5a52b3c-0f10-11e2-94c2-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-05 13:25:47.092754-04","2012-11-14 15:11:15.819832-05","1500","0"
"ab7a9220-e82d-4e53-b685-ca2b72c39dd2","bond3","","e5a52b3c-0f10-11e2-94c2-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-05 13:25:47.096358-04","2012-11-14 15:11:15.822037-05","1500","0"
"f29d29c7-15c8-4879-bd8e-e0b22ce42a39","bond0","","e5a52b3c-0f10-11e2-94c2-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-05 13:25:47.100471-04","2012-11-14 15:11:15.82839-05","1500","0"
"d9be872b-2114-47a6-99ae-8be459c9e79a","bond1","","e5a52b3c-0f10-11e2-94c2-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-05 13:25:47.10407-04","2012-11-14 15:11:15.831098-05","1500","0"
"d689ce0e-fdce-4460-a7d9-db70dbd5361e","bond2","","e5a52b3c-0f10-11e2-94c2-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-05 13:25:47.107418-04","2012-11-14 15:11:15.833994-05","1500","0"
"59d3a367-818f-4264-99d2-98c8114f8b5e","bond4","","acb1a7d6-122d-11e2-9f25-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-09 12:36:20.423303-04","2012-11-14 15:11:18.744598-05","1500","0"
"b0369321-0285-4757-b991-8c2e74f33706","bond3","","acb1a7d6-122d-11e2-9f25-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-09 12:36:20.426796-04","2012-11-14 15:11:18.750523-05","1500","0"</pre>
</div>