Axel Wers Posted April 10, 2022 Share Posted April 10, 2022 Hello, I use IPB since 2006 year and I used to some modules and plugins. During this long time IPB changes some tables, so in my database I have some obsolete tables (for example the first one bbcode_mediatag is like that). In bold should be an obsolete tables, no longer used by Invision community or unistalled modules. I use the latest iVC 4.6.12 - Board, Blog, Gallery, Pages and Calendar. Which tables can I remove from database? I would remove in bold, but maybe there are some to delete else. Thanks. Quote bbcode_mediatag blog_blogs blog_categories blog_comments blog_entries blog_entry_categories calendar_calendars calendar_event_comments calendar_event_reminders calendar_event_reviews calendar_event_rsvp calendar_events calendar_import_feeds calendar_import_map calendar_venueschat_log_archiveclassifieds_conditions cms_blocks cms_containers cms_database_categories cms_database_comments cms_database_fields cms_database_fields_reciprocal_map cms_database_fields_thumbnails cms_database_reviews cms_database_revisions cms_databases cms_folders cms_media cms_media_folders cms_page_widget_areas cms_pages cms_template_conflicts cms_templates cms_url_store conf_settings conf_settings_titles core_achievements_log core_achievements_log_milestones core_achievements_rules core_acp_notifcations_dismissals core_acp_notifications core_acp_notifications_preferences core_acp_search_index core_acp_tab_order core_acronyms core_admin_login_logs core_admin_logs core_admin_permission_rows core_advertisements core_announcements core_anonymous_posts core_api_keys core_api_logs core_api_webhook_fires core_api_webhooks core_applications core_archive_log core_archive_restore core_attachments core_attachments_map core_automatic_moderation_pending core_automatic_moderation_rules core_automatic_moderation_types core_badges core_banfilters core_bulk_mail core_cache core_club_pages core_clubs core_clubs_fields core_clubs_fieldvalues core_clubs_memberships core_clubs_node_map core_content_featured core_content_meta core_deletion_log core_dev core_edit_history core_editor_stored_replies core_email_templates core_emoticons core_error_logs core_file_logs core_file_storage core_files core_files_temp core_follow core_follow_count_cache core_geoip_cache core_googleauth_used_codes core_group_promotions core_groups core_hooks core_hooks_files core_ignored_users core_incoming_emails core_inline_messages core_ips_bulletins core_item_markers core_item_member_map core_item_redirect core_item_statistics_cache core_javascript core_leaders core_leaders_groups core_like_cache core_log core_login_handlers core_login_links core_login_methods core_mail_error_logs core_marketplace_tokens core_member_badges core_member_history core_member_ranks core_member_recognize core_member_status_replies core_member_status_updates core_members core_members_feature_seen core_members_features core_members_known_devices core_members_known_ip_addresses core_members_logins core_members_warn_actions core_members_warn_logs core_members_warn_reasons core_menu core_message_posts core_message_topic_user_map core_message_topics core_moderator_logs core_moderators core_modules core_notification_defaults core_notification_preferences core_notifications core_notifications_pwa_keys core_notifications_pwa_queue core_oauth_authorize_prompts core_oauth_clients core_oauth_server_access_tokens core_oauth_server_authorization_codes core_output_cache core_permission_index core_pfields_content core_pfields_data core_pfields_groups core_plugins core_points_log core_polls core_post_before_registering core_profanity_filters core_profile_completion core_profile_steps core_question_and_answer core_queue core_ratings core_rc_comments core_rc_index core_rc_reports core_reactions core_referral_banners core_referrals core_reputation_index core_reputation_leaderboard_history core_reputation_levels core_rss_export core_rss_import core_rss_imported core_s3_deletions core_saved_charts core_search_index core_search_index_item_map core_search_index_tags core_security_answers core_security_questions core_seo_meta core_sessions core_share_links core_sitemap core_social_promote core_social_promote_content core_social_promote_sharers core_soft_delete_log core_solved_index core_spam_service_log core_spam_whitelist core_statistics core_store core_stream_subscriptions core_streams core_sys_conf_settings core_sys_cp_sessions core_sys_lang core_sys_lang_words core_sys_login core_sys_settings_titles core_sys_social_group_members core_sys_social_groups core_tags core_tags_cache core_tags_perms core_tasks core_tasks_log core_theme_conflict core_theme_content_history core_theme_css core_theme_resources core_theme_settings_fields core_theme_settings_values core_theme_templates core_themes core_upgrade_history core_validating core_view_updates core_voters core_widget_areas core_widget_trash core_widgets custom_bbcode forums_answer_ratings forums_archive_posts forums_archive_rules forums_forums forums_posts forums_question_ratings forums_topic_mmod forums_topics forums_view_method gallery_album_comments gallery_album_reviews gallery_albums gallery_bandwidth gallery_categories gallery_comments gallery_images gallery_images_uploads gallery_reviews rc_reports_index reg_antispamshoutbox_stats shoutbox_upgrade_history subscription_currency subscription_extra subscription_logs subscription_methods subscription_trans subscriptions x_utf_convert_session x_utf_convert_session_tables Those two last with x_utf_ prefix are important too? Link to comment Share on other sites More sharing options...
Miss_B Posted April 10, 2022 Share Posted April 10, 2022 You can compare all the tables with the default tables added by the Ipb 4.6 and remove the ones that are extra. But be careful to not remove any tables added by apps or plugins that you are currently using though. Axel Wers 1 Link to comment Share on other sites More sharing options...
Marc Posted April 11, 2022 Share Posted April 11, 2022 While we cannot assist with cleanup tasks, on a very quick comparison, these are the ones I come up with. Note however, you need to make sure you take a full backup of your site before you continue. It may be worth just renaming them to begin with, then leave them for a period of time you feel comfortable it has caused no issues. bbcode_mediatag chat_log_archive classifieds_conditions conf_settings conf_settings_titles core_archive_log core_archive_restore core_hooks_files core_inline_messages core_like_cache core_login_handlers core_sys_login core_sys_settings_titles custom_bbcode rc_reports_index reg_antispam shoutbox_stats shoutbox_upgrade_history subscription_currency subscription_extra subscription_logs subscription_methods subscription_trans subscriptions Ehren and Miss_B 2 Link to comment Share on other sites More sharing options...
Axel Wers Posted April 24, 2022 Author Share Posted April 24, 2022 Thanks, I can try this. @Marc Stridgen those tables with prefix core_ are not used anymore? Link to comment Share on other sites More sharing options...
Marc Posted April 25, 2022 Share Posted April 25, 2022 18 hours ago, Axel Wers said: Thanks, I can try this. @Marc Stridgen those tables with prefix core_ are not used anymore? The ones I mention above arent. Do not delete all tables beginning with core_ though Link to comment Share on other sites More sharing options...
Recommended Posts