DX Infrastructure Management

Expand all | Collapse all

Export UMP Media

  • 1.  Export UMP Media

    Posted 08-06-2019 09:54 AM
    ​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:

    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

  • 2.  RE: Export UMP Media

    Posted 08-06-2019 11:58 AM
    thanks for sharing this!!!

    Gene Howard
    Principal Support Engineer

  • 3.  RE: Export UMP Media

    Posted 08-06-2019 12:45 PM
    My pleasure Gene :)

    CA - UIM administrator