deviantintegral

#!/usr/bin/env bash

# Compress MySQL tables on disk.
# Author: Andrew Berry, [email protected]
#
# Compress all tables in a MySQL InnoDB database using compression from the
# Barracuda table format. Tables have to already be in the Barracuda file
# format to actually compress tables, otherwise the table setting is ignored.
#
# innodb_file_per_table = 1 MUST be set in my.cnf for compression to work.

deviantintegral

     o
   _ | _     
 [| ◡ ◡ |]
 _ - ⏝ - _  
|         |
|  |   |  |

deviantintegral

<?php

db_query("TRUNCATE {kaltura_custom_data}");

$result = db_query("SELECT id FROM {kaltura_full_metadata}");

$count = 0;
while ($id = db_result($result)) {
  $count++;

deviantintegral

#!/bin/bash

(for i in `echo 'SHOW TABLES;' | mysql -u root --password=MYPASS -h localhost drupal7  | grep -v Tables_in`; do echo "DROP TABLE $i;"; done;) | mysql -u root --password=MYPASS -h localhost drupal7

deviantintegral

<?php

db_query("TRUNCATE {kaltura_custom_data}");

$result = db_query("SELECT id FROM {kaltura_full_metadata}");

$count = 0;
while ($id = db_result($result)) {
  $count++;

deviantintegral

SELECT kfm.id,
       n.title,
       kvu.file_and_folder,
       kfm.id AS "metadata:kaltura_id"
FROM   kaltura_full_metadata kfm
       LEFT JOIN node_kaltura nk
         ON kfm.id = nk.kaltura_entryid
       LEFT JOIN node n
         ON nk.nid = n.nid
       LEFT JOIN kaltura_video_and_audio_urls kvu

deviantintegral

SELECT kfm.id                                     AS id,
       IF(n.title IS NOT NULL, n.title, kfm.name) AS title,
       Concat("Source_Video/", kvu.file_name)     AS video,
       IF(n.title IS NOT NULL, "/kaltura import",
       "/kaltura_import,/no g365 node id")
       AS labels,
       kfm.id                                     AS "metadata:kaltura_id"
FROM   kaltura_full_metadata kfm
       LEFT JOIN node_kaltura nk
         ON kfm.id = nk.kaltura_entryid