exportinSQLformatincludesallProcedures

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.

• Original URL: "https://sourceforge.net/p/phpmyadmin/bugs/2425/":https://sourceforge.net/p/phpmyadmin/bugs/2425/


• Original author: hartmutg


• Found in version: 2.10.1

该提问来源于开源项目：phpmyadmin/phpmyadmin