#2326 (ok 2.10.0) Export & Importing views

2.9.1.1
fixed
1
2013-06-11
2006-12-23
Zon Net
No

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

Discussion

  • Marc Delisle

    Marc Delisle - 2006-12-23
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2006-12-23

    Logged In: YES
    user_id=210714
    Originator: NO

    1) duplicate for bug # 1541189

     
  • Marc Delisle

    Marc Delisle - 2006-12-26

    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.

     
  • Marc Delisle

    Marc Delisle - 2006-12-26
    • priority: 5 --> 1
    • summary: Export & Importing views --> (ok 2.10.0) Export & Importing views
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2007-02-28
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks