Rename Database Tables

Rename default WordPress tables to with a different table prefix ($table_prefix):

RENAME TABLE `wp_commentmeta` TO `xx_commentmeta`
RENAME TABLE `wp_comments` TO `xx_comments`
RENAME TABLE `wp_links` TO `xx_links`
RENAME TABLE `wp_options` TO `xx_options`;
RENAME TABLE `wp_postmeta` TO `xx_postmeta`;
RENAME TABLE `wp_posts` TO `xx_posts`;
RENAME TABLE `wp_termmeta` TO `xx_termmeta`;
RENAME TABLE `wp_terms` TO `xx_terms`;
RENAME TABLE `wp_term_relationships` TO `xx_relationships`;
RENAME TABLE `wp_term_taxonomy` TO `xx_taxonomy`;
RENAME TABLE `wp_usermeta` TO `xx_usermeta`;
RENAME TABLE `wp_users` TO `xx_users`;

Leave a comment

BlogLogistics