Menu
▾
▴
#2326 (ok 2.10.0) Export & Importing views
When exporting a database:
1) Views are not visable in export list (request 1541189) and cannot be excluded from export; they're always included in export file.
2) When importing a file containing views depending on other views in same script gives errors due to dependencies.
If views could be isolated in export list and the view creation statement in the export file would be
'create or replace view ...' in stead of
'create view ...' one could import the view-export-file several times to re-create all views.
Perhaps better solutions are available ...
Logged In: YES
user_id=210714
Originator: NO
1) duplicate for bug # 1541189
Logged In: YES
user_id=210714
Originator: NO
2) fixed by supporting VIEW dependencies: a stand-in CREATE TABLE is generated and later dropped. Please try the current dev version in a few hours when the demo is synchronized (http://www.phpmyadmin.net/home_page/demos.php)
and post your feedback here.