The CiviCRM installation for InformAzioni.wiki is not being in use since some years. Confirmed by C.
We have the opportunity to cleanup files and the database to reduce attack surface and cleaning up data.
Description
Description
Event Timeline
Comment Actions
Complete backup shared to c.
$ sha256sum informazioni* 9e884d57753651d1140de9c6f7e3897a2631ab878ff32a1e43a82e1b735208e8 informazioniwiki_wp.gz 07e9ef9ed1ad4a0f85b98630b126755fee880b530f741f2130457ded1d43b948 informazioni.wiki_www.tar.gz
Comment Actions
It seems CiviCRM WordPress has not a way to cleanup the database. See this TODO:
https://github.com/civicrm/civicrm-wordpress/blob/master/uninstall.php#L31
Comment Actions
Tables:
$ SELECT table_name FROM information_schema.tables WHERE table_type = 'BASE TABLE' AND table_schema = 'informazioniwiki_wp' AND table_name LIKE 'civicrm%'; +------------------------------------------+ | table_name | +------------------------------------------+ | civicrm_address | | civicrm_pcp_block | | civicrm_website | | civicrm_install_canary | | civicrm_discount | | civicrm_extension | | civicrm_persistent | | civicrm_location_type | | civicrm_mailing_job | | civicrm_payment_processor | | civicrm_contribution_product | | civicrm_cxn | | civicrm_mapping_field | | civicrm_im | | civicrm_uf_group | | civicrm_component | | civicrm_membership | | civicrm_contribution_recur | | civicrm_batch | | civicrm_tell_friend | | civicrm_setting | | civicrm_acl_contact_cache | | civicrm_case_type | | civicrm_contribution_widget | | civicrm_membership_type | | civicrm_recurring_entity | | civicrm_entity_batch | | civicrm_option_value | | civicrm_group | | civicrm_action_schedule | | civicrm_group_nesting | | civicrm_uf_join | | civicrm_pledge_block | | civicrm_status_pref | | civicrm_tag | | civicrm_price_field_value | | civicrm_price_set_entity | | civicrm_contribution | | civicrm_survey | | civicrm_dedupe_rule_group | | civicrm_job_log | | civicrm_preferences_date | | civicrm_mailing_spool | | civicrm_group_contact | | civicrm_prevnext_cache | | civicrm_relationship_type | | civicrm_mailing_event_delivered | | civicrm_entity_tag | | civicrm_campaign | | civicrm_participant | | civicrm_county | | civicrm_membership_status | | civicrm_price_set | | civicrm_dashboard_contact | | civicrm_dedupe_rule | | civicrm_queue_item | | civicrm_state_province | | civicrm_timezone | | civicrm_mailing_event_confirm | | civicrm_case_activity | | civicrm_mailing_event_reply | | civicrm_sms_provider | | civicrm_mailing | | civicrm_entity_file | | civicrm_phone | | civicrm_print_label | | civicrm_participant_payment | | civicrm_mail_settings | | civicrm_report_instance | | civicrm_saved_search | | civicrm_grant | | civicrm_membership_log | | civicrm_email | | civicrm_contact | | civicrm_contribution_page | | civicrm_custom_field | | civicrm_financial_trxn | | civicrm_mailing_event_trackable_url_open | | civicrm_openid | | civicrm_premiums | | civicrm_uf_field | | civicrm_relationship | | civicrm_payment_processor_type | | civicrm_event | | civicrm_option_group | | civicrm_case | | civicrm_worldregion | | civicrm_activity | | civicrm_mailing_recipients | | civicrm_mailing_bounce_type | | civicrm_mailing_trackable_url | | civicrm_contact_type | | civicrm_entity_financial_trxn | | civicrm_membership_block | | civicrm_events_in_carts | | civicrm_acl_cache | | civicrm_mailing_component | | civicrm_campaign_group | | civicrm_financial_account | | civicrm_group_organization | | civicrm_participant_status_type | | civicrm_contribution_soft | | civicrm_currency | | civicrm_note | | civicrm_mailing_event_subscribe | | civicrm_msg_template | | civicrm_case_contact | | civicrm_mailing_event_opened | | civicrm_financial_type | | civicrm_uf_match | | civicrm_mailing_event_unsubscribe | | civicrm_mailing_group | | civicrm_menu | | civicrm_financial_item | | civicrm_price_field | | civicrm_domain | | civicrm_pledge | | civicrm_system_log | | civicrm_dedupe_exception | | civicrm_word_replacement | | civicrm_product | | civicrm_mailing_event_bounce | | civicrm_mailing_event_forward | | civicrm_job | | civicrm_custom_group | | civicrm_acl_entity_role | | civicrm_line_item | | civicrm_cache | | civicrm_mapping | | civicrm_activity_contact | | civicrm_file | | civicrm_managed | | civicrm_pcp | | civicrm_dashboard | | civicrm_mailing_abtest | | civicrm_action_mapping | | civicrm_mailing_bounce_pattern | | civicrm_log | | civicrm_entity_financial_account | | civicrm_loc_block | | civicrm_membership_payment | | civicrm_action_log | | civicrm_country | | civicrm_pledge_payment | | civicrm_acl | | civicrm_premiums_product | | civicrm_address_format | | civicrm_subscription_history | | civicrm_payment_token | | civicrm_event_carts | | civicrm_group_contact_cache | | civicrm_navigation | | civicrm_mailing_event_queue | +------------------------------------------+ 153 rows in set (0,004 sec)
SELECT CONCAT('DROP VIEW ', table_name, ';') as `sql` FROM information_schema.tables WHERE table_schema = 'informazioniwiki_wp' AND TABLE_TYPE LIKE 'VIEW' AND table_name LIKE 'civicrm%';
+--------------------------------------------------+
| sql |
+--------------------------------------------------+
| DROP VIEW civicrm_contribution_page_it_IT; |
| DROP VIEW civicrm_custom_field_it_IT; |
| DROP VIEW civicrm_membership_status_it_IT; |
| DROP VIEW civicrm_custom_group_it_IT; |
| DROP VIEW civicrm_event_it_IT; |
| DROP VIEW civicrm_pcp_block_it_IT; |
| DROP VIEW civicrm_tell_friend_it_IT; |
| DROP VIEW civicrm_premiums_it_IT; |
| DROP VIEW civicrm_option_value_it_IT; |
| DROP VIEW civicrm_price_set_it_IT; |
| DROP VIEW civicrm_location_type_it_IT; |
| DROP VIEW civicrm_relationship_type_it_IT; |
| DROP VIEW civicrm_option_group_it_IT; |
| DROP VIEW civicrm_membership_block_it_IT; |
| DROP VIEW civicrm_group_it_IT; |
| DROP VIEW civicrm_membership_type_it_IT; |
| DROP VIEW civicrm_case_type_it_IT; |
| DROP VIEW civicrm_payment_processor_it_IT; |
| DROP VIEW civicrm_survey_it_IT; |
| DROP VIEW civicrm_participant_status_type_it_IT; |
| DROP VIEW civicrm_price_field_value_it_IT; |
| DROP VIEW civicrm_price_field_it_IT; |
| DROP VIEW civicrm_contact_type_it_IT; |
| DROP VIEW civicrm_product_it_IT; |
| DROP VIEW civicrm_uf_field_it_IT; |
| DROP VIEW civicrm_batch_it_IT; |
| DROP VIEW civicrm_dashboard_it_IT; |
| DROP VIEW civicrm_uf_group_it_IT; |
+--------------------------------------------------+
28 rows in set (0,002 sec)Comment Actions
Nuclearized CiviCRM.
The dump, compressed, is down from 1.4M to 732K. Uh. Noice.
The files, compressed, is down from 379.8MB to 384MB. Uh. Noice.