Shell to export each mysql stored procedure as a single file,
# Shell implementation: export the Stored Procedure Code in mysql as the file dbcn = "mysql-h172.16.1.194-uroot-p123456"; db = BCReport_Sync_Executor; ii = 0; ct = '$ dbcn-N-e "select count (1) from mysql. proc as p where 1 = 1 and p. db = '$ db' and p. type like 'P % '; "'; mkdir-P/chenenhui/$ dbwhile true; doif [$ ii-lt $ ct] then p = $ ii; let ii ++; echo p = $ p echo ii = $ iispname = '$ dbcn-N-e "select p. name from mysql. proc as p where 1 = 1 and p. db = '$ db' and p. type like 'P % 'limit $ P, 1; "'; echo spname = $ spnamesleep 0; ss = '$ dbcn-N-e" select concat ('delimi ', 'ter ', REPEAT (CHAR (36), 2), 'use', CHAR (96), p. db, CHAR (96), REPEAT (CHAR (36), 2), 'drop procedure if exists', CHAR (96), p. name, CHAR (96), REPEAT (CHAR (36), 2), 'create DEFINER = ', CHAR (96), LEFT (DEFINER, -1 + LOCATE ('@', DEFINER), CHAR (96), '@', CHAR (96), RIGHT (DEFINER, LENGTH (DEFINER) -LOCATE ('@', DEFINER), CHAR (96), 'Procedure ', CHAR (96), p. name, CHAR (96), '(', p. param_list, ')', p. body_utf8, REPEAT (CHAR (36), 2), 'delimi', 'ter; ') AS SQL _create FROM mysql. proc AS p WHERE 1 = 1 and p. db = '$ db' and p. type LIKE 'P % 'and p. name = '$ spname'; "'echo-e" $ ss ">/chenenhui/$ db/$ spname. sqlecho $ spnameelse echo '_ while finished'; exit 0; fidone