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.drakopou...@nokia.com <mailto:dionisis.drakopou...@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@lists.openstack.org
    <mailto:openstack@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@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@lists.openstack.org
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack

Reply via email to