Monday, December 04, 2006

database cleanup

Some misc stuff takes up so much time! Checking disc contents at Melb and Jo'berg, verifying which files are missing locally and which missing remotely, etc and the usual mails and so on took up the whole morning! Anyway, useful, since it cleaned up some space at Jo'berg by deleting some wav files, and got one Conversation out of hibernation which had missed being sent to Melb.

Commented out the last line of import_broadcastcenter_files.sh deleting temp table in database, did the query as
select "filename" from file_id where filename not in (select filename from temp);
and
select "filename" from temp where filename not in (select filename from file_id);

No comments:

Post a Comment