I created all my stored procedures with username@XX.XX.XX.XX as the DEFINER value. Now, since I changed my location, so the IP address I can not view or export the code.
My code is on shared hosting, and the support team does not want to help in this matter.
Any ideas on how to get to the code? Even a full database export does not contain stored procedure code. It contains only the data that is inserted into the 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',
'', 'username@XX.XX.XX.XX', 'latin1', 'latin1_swedish_ci',
'latin1_swedish_ci'),
thank