Skip navigation links

MySQL Forums :: Stored Procedures :: import stored procedure using mysqldump fails


Advanced Search

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


Subject Views Written By Posted
import stored procedure using mysqldump fails 1381 suntosh naik 04/16/2012 07:42AM
Re: import stored procedure using mysqldump fails 741 Rick James 04/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.