DX Infrastructure Management

Expand all | Collapse all

Export UMP Media

  • 1.  Export UMP Media

    Posted 16 days ago
    ​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
    ------------------------------


  • 2.  RE: Export UMP Media

    Posted 16 days ago
    thanks for sharing this!!!

    ------------------------------
    Gene Howard
    Principal Support Engineer
    Broadcom
    ------------------------------



  • 3.  RE: Export UMP Media

    Posted 16 days ago
    My pleasure Gene :)

    ------------------------------
    CA - UIM administrator
    ------------------------------