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