phpMyAdmin

Bugs item #3062455, was opened at 2010-09-09 07:58
Message generated for change (Tracker Item Submitted) made by fisharebest
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=377408&aid=3062455&group_id=23067

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Data Export
Group: 3.3.7
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Greg Roach (fisharebest)
Assigned to: Nobody/Anonymous (nobody)
Summary: Functions/Procedures should come first in export

Initial Comment:
CREATE DATABASE test;
USE test;
CREATE FUNCTION fish() RETURNS TEXT RETURN 'are best';
CREATE VIEW fishy AS SELECT fish();

Use the database "export" function, and tick the box to include functions.

The export order is (1) tables/view, (2) functions/procedures.

You can create a function that refers to non-existent tables/views/functions.

You CANNOT create a view that refers to non-existent functions.

Hence this export file cannot be reimported without manually editing it first

Suggestion: export the routines first.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=377408&aid=3062455&group_id=23067

[Phpmyadmin-trk-bugs] [ phpmyadmin-Bugs-3062455 ] Functions/Procedures should come first in export From: SourceForge.net <noreply@so...> - 2010-09-17 07:51 Bugs item #3062455, was opened at 2010-09-09 07:58 Message generated for change (Comment added) made by fisharebest You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=377408&aid=3062455&group_id=23067 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Data Export Group: 3.3.7 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Greg Roach (fisharebest) Assigned to: Nobody/Anonymous (nobody) Summary: Functions/Procedures should come first in export Initial Comment: CREATE DATABASE test; USE test; CREATE FUNCTION fish() RETURNS TEXT RETURN 'are best'; CREATE VIEW fishy AS SELECT fish(); Use the database "export" function, and tick the box to include functions. The export order is (1) tables/view, (2) functions/procedures. You can create a function that refers to non-existent tables/views/functions. You CANNOT create a view that refers to non-existent functions. Hence this export file cannot be reimported without manually editing it first Suggestion: export the routines first. ---------------------------------------------------------------------- >Comment By: Greg Roach (fisharebest) Date: 2010-09-17 07:51 Message: The same export/import sequence is used when copying/renaming databases, and these processes also fail, for the same reason. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=377408&aid=3062455&group_id=23067

[Phpmyadmin-trk-bugs] [ phpmyadmin-Bugs-3062455 ] Functions/Procedures should come first in export From: SourceForge.net <noreply@so...> - 2010-09-27 17:01 Bugs item #3062455, was opened at 2010-09-09 09:58 Message generated for change (Settings changed) made by ruleant You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=377408&aid=3062455&group_id=23067 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Data Export Group: 3.3.7 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Greg Roach (fisharebest) >Assigned to: Dieter Adriaenssens (ruleant) Summary: Functions/Procedures should come first in export Initial Comment: CREATE DATABASE test; USE test; CREATE FUNCTION fish() RETURNS TEXT RETURN 'are best'; CREATE VIEW fishy AS SELECT fish(); Use the database "export" function, and tick the box to include functions. The export order is (1) tables/view, (2) functions/procedures. You can create a function that refers to non-existent tables/views/functions. You CANNOT create a view that refers to non-existent functions. Hence this export file cannot be reimported without manually editing it first Suggestion: export the routines first. ---------------------------------------------------------------------- Comment By: Greg Roach (fisharebest) Date: 2010-09-17 09:51 Message: The same export/import sequence is used when copying/renaming databases, and these processes also fail, for the same reason. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=377408&aid=3062455&group_id=23067

11 messages have been excluded from this view by a project administrator.