SagePtr

drop procedure if exists dump_image;
delimiter //
create procedure dump_image()
begin

declare this_id int;
declare cur1 cursor for select imageId from image;
open cur1;
  read_loop: loop
    fetch cur1 into this_id;
    set @query = concat('select blob_field from image where imageId=', 
        this_id, ' into outfile "/tmp/xyz-', this_id,'.jpg"');
    prepare write_file from @query;
    execute write_file;
  end loop;
close cur1;
end //
delimiter ;