Monday, August 15, 2011

MySql stored procedure commands

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
Posted by at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)