I try to Export import a database via Export / run Script. Since some time I get an error while importing the data and Views are not created in the destination DB.
I looked at the Export Script Code and i saw that there is an empty Create View CREATE VIEW cm_adr AS ;
I looked further and saw that there is something with a temporary Table but the view is not created properly.
Any suggestions what is going wrong here?
Im using heidisql 11.3.0.6295 Portable
..... SELECT -- Exportiere Struktur von View xxxxxx.cm_adr -- Erstelle temporäre Tabelle um View Abhängigkeiten zuvorzukommen CREATE TABLE cm_adr ( adr_id INT(11) NOT NULL, .....
More Statements
..... -- Exportiere Struktur von View xxxxxxx.cm_adr -- Entferne temporäre Tabelle und erstelle die eigentliche View DROP TABLE IF EXISTS cm_adr; CREATE VIEW cm_adr AS ; ......