I have discovered a little problem in exporting dependent views with adminer. Example situation:
CREATE TABLE foo (bar INT);
CREARE VIEW afoo AS SELECT bar FROM foo;
CREATE VIEW aafoo AS SELECT bar FROM afoo;
when exporting this, if view aafoo is exported first, the result script does not work - it tries to create aafoo, but view afoo doest not exist yet.
I've found this bug because I'm using my own export script in my web app and face exactly the same problem;
The only solution I found is in phpmyadmin, which first creates tables of the same name and column types as exported views, then deletes each of them just before creating corresponding view.
Log in to post a comment.