Hello,
When I needed to fix all the OpenStack DB schemas, I used to dump a
pre-production clean DB with mysqldump [...] --no-data[1] and compare it
to the production one.
It worked very well for fixing things up or looking at structure.
See you,
Regards
*[1] --no-data*,*-d*
Do not write any row information for the table. This is very useful
if you want to get a dump of only the structure for a table.
Le 03/12/2015 14:30, Alberto Molina Coballes a écrit :
> Hi Dionisis,
>
> Reading your question I've remembered a python script that generates
> OpenStack ER diagrams and I've found it again:
>
> https://coderwall.com/p/pngadg/er-diagram-for-openstack-database
>
> It's really nice and simple, but it needed an update:
>
> https://github.com/albertomolina/openstack-db-schema
>
> Maybe you can find it useful.
>
> Cheers
>
> Alberto
>
> 2015-12-03 8:45 GMT+01:00 Drakopoulos, Dionisis (Nokia - GR/Athens)
> <dionisis.drakopoulos at nokia.com <mailto:dionisis.drakopoulos at nokia.com>>:
>
> Good morning from Greece!
>
> Does anybody know where to find a valid Database schema for
> OpenStack releases?
>
> If not one for all projects, then at least for core ones.
>
> Thank you!
>
> *Dionisis (Dennis) Drakopoulos**
> **OMP MP SW Engineer/SyVe/Maintenance/SL***
>
> *MBB OMP MP R&D 14 GR***
>
> ____________________________
>
>
> _______________________________________________
> Mailing list:
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
> Post to : openstack at lists.openstack.org
> <mailto:openstack at lists.openstack.org>
> Unsubscribe :
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>
>
>
>
> _______________________________________________
> Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
> Post to : openstack at lists.openstack.org
> Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20151210/9e4f90e4/attachment.html>