SQL

AOL - Time Warner (Time Inc. Research Center)

Web Applications Development Manager

System Administration on Linux, SGI Indys, and Sun E-450 servers. Built backup systems into Linux servers while recreating and/or maintaining the authentication, cronjobs, services, and CGI operations that were previously in place. Coordinated Requirements and Update Meetings between management, end-users, and the “tech team” for communication about various projects. Used PHP, Perl, SQL, and Javascript to rebuild Celebrity Contacts - a revenue generating (previously commercially built [by Showbase]) service used by other departments.

Taxonomy Tables and relations

The following is a list and descriptions of the taxonomy tables used by Drupal 6. In depth description and explanations are not provided here. I'm only listing them because I've had a hard time finding a list myself. BYODD (Backup YOur Database, Dummy) before changing these tables.

-- VOCABULARY TABLES --
custom_breadcrumbs_taxonomy_vocabulary : Added by the Custom Breadcrumbs Taxonomy module. I don't know how it's used at this time.
vocabulary : Assigns an ID to a vocabulary name and stores the description, weight, hierarchy, and other metadata about vocabularies

Use MySQL to delete terms to save me from the single-term manual delete process.

I needed to delete a bunch (Over 100) of child terms from a Vocabulary and save the parents.
I needed to do this without sitting in front of a web browser and waiting for a page to load every time.

Disclaimer: BYODD (Backup YOur Database, Dummy!) before attempting any instructions on this site. Owners AND all Affiliates are NOT responsible for anything YOU screw up by following any instructions you find here.

Anyway... I'll cut to the chase... then explain. here are the queries I ran:

Technologies:

Move taxonomy terms to a new vocabulary while retaining Term IDs (tid) with an added bonus

I've been tasked with tightening up our site's taxonomy. Unfortunately, this includes yet another desire that cannot be met with any of the default tools available in Drupal (and noone has quite hit the mark with a module): Gather terms from multiple vocabularies into one single vocabulary and do it in such a way as to avoid recategorizing the thousands of nodes we have that have already been categorized using the existing terms. The reason for this was that all the vocabulary names could be seen as one.

Subscribe to RSS - SQL