[Phpmyadmin-devel] XML export/import : view of view

Marc Delisle marc at infomarc.info
Sat Dec 25 21:01:50 CET 2010

Le 2010-12-25 06:35, Dieter Adriaenssens a écrit :
> Hi all,
> I'd like your opinion about exporting view of view in xml format.
> Aamir Khan prepared a patch [0] that creates an XML export in the way
> this is handled in SQL export, ie first all tables and views are
> exported. All views are exported as standin tables with the same
> structure. Then all views are recreated, first dropping the standin
> tables, and creating the real views. The reason for this is to make
> sure that when creating a view that uses another view, it at least
> exists, thus avoiding an error upon importing it again.
> Downside of this is that the xml export of the structure schema gets a
> bit confusing with a <pma:table>, <pma:drop> and <pma:view> tag for
> every view, as the xml export is intended to be used by custom
> scripting.
> Another idea is just to export the schema structure with one tag for a
> view (without the extra table and drop parts), and make some changes
> to the xml import code, to handle the correct creation of the views.

Has a patch been contributed to implement this second idea? If not, how
complex would be "some changes"?

> Any ideas?
> [0] http://sourceforge.net/tracker/?func=detail&aid=3141565&group_id=23067&atid=377410

Marc Delisle

More information about the Developers mailing list