1. To show all stored procedures of a database:
SHOW PROCEDURE STATUS where DB = 'databasename';
2. Dump(export) all stored procedures of a database
mysqldump -uuser -ppassword --routines databasename > outputfile.sql
Showing posts with label stored procedure. Show all posts
Showing posts with label stored procedure. Show all posts
Monday, August 15, 2011
Subscribe to:
Posts (Atom)