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

Dieter Adriaenssens dieter.adriaenssens at gmail.com
Sat Dec 25 12:35:45 CET 2010

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

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.

Any ideas?

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

Kind regards and Merry Christmas,

Dieter Adriaenssens

More information about the Developers mailing list