import stored procedure using mysqldump fails
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;
Subject
Views
Written By
Posted
import stored procedure using mysqldump fails
2315
April 16, 2012 07:42AM
1215
April 17, 2012 09:32AM
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.