Menu

#2425 (ok 2.10.2) export in SQL format includes all Procedures

2.10.1
fixed
1
2013-06-11
2007-05-09
HartmutG
No

When you export a table (or a query) in SQL format, all the Stored Procedures and Stored Functions of the same database are included in the result. I found no checkbox or configuration switch to avoid this.

I get this error with phpMyAdmin 2.9.1.1 on MySQL 5.0.27 and with phpMyAdmin 2.10.1 on MySQL 5.0.38.

How to produce:
- select a table or run a query
- click on Export-Button
- choose SQL as the format
- keep any other options as defaults
- enable the last option "save as file"
- click on "Go" button
Result: the file includes behind the data all the Stored Procedures and Stored Functions of the same database.

This is irritating and a little dangerous, because if somebody imports this file, all of his Stored Procedures and Stored Functions will be mixed or replaced by the versions in the file.

Discussion

  • HartmutG

    HartmutG - 2007-05-09

    example for exporting a small table

     
  • Marc Delisle

    Marc Delisle - 2007-05-19
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2007-05-20

    Logged In: YES
    user_id=210714
    Originator: NO

    Fixed for 2.10.2: added a checkbox.

     
  • Marc Delisle

    Marc Delisle - 2007-05-20
    • priority: 5 --> 1
    • summary: export in SQL format includes all Stored Procedures --> (ok 2.10.2) .export in SQL format includes all Procedures
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2007-05-20
    • summary: (ok 2.10.2) .export in SQL format includes all Procedures --> (ok 2.10.2) export in SQL format includes all Procedures
     
  • Marc Delisle

    Marc Delisle - 2007-06-15
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

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