Skip to content

Instantly share code, notes, and snippets.

@daniloroddrigues
Last active March 8, 2024 23:40
Show Gist options
  • Save daniloroddrigues/84e040f4601d3bc265456e7d4ed63465 to your computer and use it in GitHub Desktop.
Save daniloroddrigues/84e040f4601d3bc265456e7d4ed63465 to your computer and use it in GitHub Desktop.
How to change the prefix of the database tables on WordPress
RENAME table wp_actionscheduler_actions TO new_actionscheduler_actions;
RENAME table wp_actionscheduler_claims TO new_actionscheduler_claims;
RENAME table wp_actionscheduler_groups TO new_actionscheduler_groups;
RENAME table wp_actionscheduler_logs TO new_actionscheduler_logs;
RENAME table wp_commentmeta TO new_commentmeta;
RENAME table wp_comments TO new_comments;
RENAME table wp_links TO new_links;
RENAME table wp_options TO new_options;
RENAME table wp_postmeta TO new_postmeta;
RENAME table wp_posts TO new_posts;
RENAME table wp_rank_math_404_logs TO new_rank_math_404_logs;
RENAME table wp_rank_math_analytics_adsense TO new_rank_math_analytics_adsense;
RENAME table wp_rank_math_analytics_ga TO new_rank_math_analytics_ga;
RENAME table wp_rank_math_analytics_gsc TO new_rank_math_analytics_gsc;
RENAME table wp_rank_math_analytics_inspections TO new_rank_math_analytics_inspections;
RENAME table wp_rank_math_analytics_keyword_manager TO new_rank_math_analytics_keyword_manager;
RENAME table wp_rank_math_analytics_objects TO new_rank_math_analytics_objects;
RENAME table wp_rank_math_internal_links TO new_rank_math_internal_links;
RENAME table wp_rank_math_internal_meta TO new_rank_math_internal_meta;
RENAME table wp_termmeta TO new_termmeta;
RENAME table wp_terms TO new_terms;
RENAME table wp_term_relationships TO new_term_relationships;
RENAME table wp_term_taxonomy TO new_term_taxonomy;
RENAME table wp_usermeta TO new_usermeta;
RENAME table wp_users TO new_users;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment