Export Import and Views

roan's profile image roan posted 3 years ago in General Permalink

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 ; ......

Please login to leave a reply, or register at first.