Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.There are lots of tables in our database for drupal.org. We don't need all of them.
In reviewing #636340: Provide generally available, regular exports of already public data from the drupal.org database it would be easier if we only had tables that we really use. Here are 36 tables I think we can drop out of our 182.
Here's what I suggest dropping (all are empty):
bans
blog_seq
blog
book_seq
category
channel
chatevents
chatmembers
client_system
crons
diaries
entry
faqs
forum_seq
moderation_filters
page_seq
story_seq
topic
xapian_index_queue
And I suggest backing up and dropping (not empty):
client
devel_queries
devel_times (814,896 rows)
directory
donations
dries_test
feature
forum2
google
moderation_roles
moderation_votes
old_revisions
notify
rating
smileys
sequences
test
Comments
Comment #1
moshe weitzman commentedi agree that these look safe to drop
Comment #2
hunmonk commentedi'm *pretty* sure we can also get rid of:
project_releases
project_releases_backup
i think these are relics from the older versions of project_release.module, as they don't exist in the schema anymore (this morphed into project_release_nodes + project_release_file)
might want to double check w/ dww before ripping just to be sure...
Comment #3
drummFor now I added these to the first pass sanitization.
Comment #4
drummAnd I would leave devel*, it gets turned on occasionally or needs to be properly uninstalled.
Comment #5
mikey_p commentedAlso non-empty but deprecated: project, projects, project_issues.
Newer tables are prefixed with the name of the full name of the module and the contents. (i.e. project_projects, or project_issue_comments, etc).
Comment #6
mikey_p commentedAlso a candidate for some form of archiving: cvs_*
Pretty sure forum2* is still in use as well.
Comment #7
gerhard killesreiter commentedA backup of the old tables has been created at https://association.drupal.org/intranet/infrastructure/node/966294
This doesn't include the devel modul'e tables and also not the project* ones and neither cvs*
greggles: feel free to drop the tables.
Comment #8
gregglesWell, here it is as drop statements. I removed forum2 and the devel
drop table bans;
drop table blog_seq;
drop table blog;
drop table book_seq;
drop table category;
drop table channel;
drop table chatevents;
drop table chatmembers;
drop table client_system;
drop table crons;
drop table diaries;
drop table entry;
drop table faqs;
drop table forum_seq;
drop table moderation_filters;
drop table page_seq;
drop table story_seq;
drop table topic;
drop table xapian_index_queue;
drop table client;
drop table directory;
drop table donations;
drop table dries_test;
drop table feature;
drop table google;
drop table moderation_roles;
drop table moderation_votes;
drop table old_revisions;
drop table notify;
drop table rating;
drop table smileys;
drop table sequences;
drop table test;
Let's wait a day so folks in Europe can review before really doing this.
Comment #9
gregglesTurns out, forum2 is not related to the forum2 module. There is a forum2_index that is related. So, forum2 is back to being a good table to drop.
I also decided I should just rename things first since that is easier to recover. I created a reminder to check back on August 18th and actually drop them. Here's the renames.
rename table bans TO drop_me_aug182011_bans;
rename table blog_seq TO drop_me_aug182011_blog_seq;
rename table blog TO drop_me_aug182011_blog;
rename table book_seq TO drop_me_aug182011_book_seq;
rename table category TO drop_me_aug182011_category;
rename table channel TO drop_me_aug182011_channel;
rename table chatevents TO drop_me_aug182011_chatevents;
rename table chatmembers TO drop_me_aug182011_chatmembers;
rename table client_system TO drop_me_aug182011_client_system;
rename table crons TO drop_me_aug182011_crons;
rename table diaries TO drop_me_aug182011_diaries;
rename table entry TO drop_me_aug182011_entry;
rename table faqs TO drop_me_aug182011_faqs;
rename table forum_seq TO drop_me_aug182011_forum_seq;
rename table forum2 TO drop_me_aug182011_forum2;
rename table moderation_filters TO drop_me_aug182011_moderation_filters;
rename table page_seq TO drop_me_aug182011_page_seq;
rename table story_seq TO drop_me_aug182011_story_seq;
rename table topic TO drop_me_aug182011_topic;
rename table xapian_index_queue TO drop_me_aug182011_xapian_index_queue;
rename table client TO drop_me_aug182011_client;
rename table directory TO drop_me_aug182011_directory;
rename table donations TO drop_me_aug182011_donations;
rename table dries_test TO drop_me_aug182011_dries_test;
rename table feature TO drop_me_aug182011_feature;
rename table google TO drop_me_aug182011_google;
rename table moderation_roles TO drop_me_aug182011_moderation_roles;
rename table moderation_votes TO drop_me_aug182011_moderation_votes;
rename table old_revisions TO drop_me_aug182011_old_revisions;
rename table notify TO drop_me_aug182011_notify;
rename table rating TO drop_me_aug182011_rating;
rename table smileys TO drop_me_aug182011_smileys;
rename table sequences TO drop_me_aug182011_sequences;
rename table test TO drop_me_aug182011_test;
Comment #10
gregglesDone, finally, to make #1546114: Review sanitized DB dump for D7 a little easier.