Mysql stored procedures export

Question

I had created all my stored procedures with [email protected] as DEFINER value. Now, since I've changed my location therefore the IP address I cannot view or export the code.

My code is on shared hosting and the support team does not want to help regarding this matter.

Any ideas on how to get to the code? Even a full database export does not contain the stored procedures code. It only has the data that is inserted into ROUTINES table

INSERT INTO `ROUTINES` (`SPECIFIC_NAME`, `ROUTINE_CATALOG`, `ROUTINE_SCHEMA`,
    `ROUTINE_NAME`, `ROUTINE_TYPE`, `DTD_IDENTIFIER`,
    `ROUTINE_BODY`, `ROUTINE_DEFINITION`, `EXTERNAL_NAME`, `EXTERNAL_LANGUAGE`,
    `PARAMETER_STYLE`, `IS_DETERMINISTIC`, `SQL_DATA_ACCESS`, `SQL_PATH`,
    `SECURITY_TYPE`, `CREATED`, `LAST_ALTERED`, `SQL_MODE`, `ROUTINE_COMMENT`,
    `DEFINER`, `CHARACTER_SET_CLIENT`, `COLLATION_CONNECTION`,
    `DATABASE_COLLATION`)
VALUES ('sp_sample_name', NULL, 'XXX',
    'sp_sample_name', 'PROCEDURE', NULL,
    'SQL', NULL, NULL, NULL,
    'SQL', 'NO', 'CONTAINS SQL', NULL,
    'DEFINER', '2012-03-26 01:01:14', '2012-03-26 01:01:14', 'STRICT_TRANS_TABLES',
    '', '[email protected]', 'latin1', 'latin1_swedish_ci',
    'latin1_swedish_ci'),

Thank you

Answer 1

You can call SHOW CREATE PROCEDURE.