I recently asked support if there was a way to export UMP Media and there is no supported way of doing this.
Attached is some SQL which will help in situations where you need the media files you have uploaded to the UMP.
Save this SQL:
select concat('select data into dumpfile ''/mysqlbackups/export/',substr(hex(id),28),'_',name,''' from ca_uim.umpmedia where hex(id)=''',hex(id),''';') from ca_uim.umpmedia where name like '%.mp3' order by id into outfile '/mysqlbackups/export/umpmedia_export.sql';
Name the file this:
generate_export_sql
Create a directory on your SQL Server called /mysqlbackups/export and upload the file called generate_export_sql.sql which can be run with
mysql -p < generate_export_sql.sql
And this will create a file containing sql to export all mp3s and called umpmedia_export.sql (delete this before rerunning the generate)
mysql -p < umpmedia_export.sql
This will export all the mp3s to the same directory (again delete or rename the mp3s before rerunning this)
Test on MYSQL Percona.
------------------------------
CA - UIM administrator
------------------------------