Jorgen,
Patch approved pending minor request:
> +CREATE PROCEDURE p1() SET @a=5;
> +CREATE PROCEDURE p2() SET @a=5;
Please change the procedure body so that they do something different. Like
p2 @a=100.
> +
> +--echo
> +--echo Check that procedures are there before the backup
> +
> +CALL p1();
> +CALL p2();
Please display the results here some way so we know the procedures worked.
> +
> +--echo
> +--echo Backup and restore
> +
> +--replace_column 1 #
> +BACKUP DATABASE bup_proc to 'bup_proc.bak'; DROP DATABASE bup_proc;
> +--replace_column 1 # RESTORE FROM 'bup_proc.bak';
> +
> +--echo
> +--echo Check that procedures are there after the restore
> +
> +CALL p1();
> +CALL p2();
Please display the results here some way so we know the procedures worked.
The reason for displaying the effects of the procedures is so that we know
they restored correctly.
Chuck
