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.
example for exporting a small table
Logged In: YES
user_id=210714
Originator: NO
Fixed for 2.10.2: added a checkbox.