Big B: How to import store proceedure in mysql

Tuesday, October 23, 2012

To fix this.

Export store procedure from existing database with below command;

#mysqldump -p --no-create-db --no-create-info --no-data --routines DBNAME > DBNAME_23Oct2012.sql

And imoprt .sql file to running db.

#mysql -u root -p DBNAME < DBNAME_23Oct2012.sql

Restart Mysql DB

To check Store procedure in Mysql

#Login into mysql DB and type the below command

SHOW PROCEDURE STATUS;

SHOW FUNCTION STATUS;

Thats it!!!!