dumping of database with stored procedures (SP)

[singiap]

since phpmyadmin can't support SP now, so it is impossible for us to import or export our database with SP using phpmyadmin.
BTW, we can dumping the database with SP by client/command prompt.

export the data and sprocs by the command:
mysqldump <other mysqldump options> --routines --databases <databaseName> > outputfile.sql

import the exported .sql file by the following command:
mysql <other mysql options> <databaseName> < outputfile.sql

hope this help.^-^
can also take a reference on the below article:
http://www.ducea.com/2007/07/25/dumping ... -triggers/