MySQL Forums
Forum List  »  Stored Procedures

import stored procedure using mysqldump fails
Posted by: suntosh naik
Date: April 16, 2012 07:42AM

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

is not working.

I can see only drop procedure if exist <sp_name>;
-- unable to find procedure body;

Options: ReplyQuote

Written By
import stored procedure using mysqldump fails
April 16, 2012 07:42AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.