Jump to content

Please help me clean up my database


Recommended Posts

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_venues
chat_log_archive
classifieds_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_antispam
shoutbox_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

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

Link to comment
Share on other sites

  • 2 weeks later...
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...