WordPress技巧：修改 WordPress 数据库前缀

1

$table_prefix  = 'cmh_';

1
2
3
4
5
6
7
8
9
10
11

RENAME table 'wp_commentmeta' TO 'cmh_commentmeta';
RENAME table 'wp_comments' TO 'cmh_comments';
RENAME table 'wp_links' TO 'cmh_links';
RENAME table 'wp_options' TO 'cmh_options';
RENAME table 'wp_postmeta' TO 'cmh_postmeta';
RENAME table 'wp_posts' TO 'cmh_posts';
RENAME table 'wp_terms' TO 'cmh_terms';
RENAME table 'wp_term_relationships' TO 'cmh_term_relationships';
RENAME table 'wp_term_taxonomy' TO 'cmh_term_taxonomy';
RENAME table 'wp_usermeta' TO 'cmh_usermeta';
RENAME table 'wp_users' TO 'cmh_users';

1

SELECT REPLACE(option_name, 'wp_', 'cmh_') FROM cmh_options;

1

SELECT REPLACE(meta_key, 'wp_', 'cmh_') FROM cmh_usermeta;