如何修改 WordPress 数据库前缀

1

$table_prefix  = 'wpdx_';

1
2
3
4
5
6
7
8
9
10
11

RENAME table 'wp_commentmeta' TO 'wpdx_commentmeta';
RENAME table 'wp_comments' TO 'wpdx_comments';
RENAME table 'wp_links' TO 'wpdx_links';
RENAME table 'wp_options' TO 'wpdx_options';
RENAME table 'wp_postmeta' TO 'wpdx_postmeta';
RENAME table 'wp_posts' TO 'wpdx_posts';
RENAME table 'wp_terms' TO 'wpdx_terms';
RENAME table 'wp_term_relationships' TO 'wpdx_term_relationships';
RENAME table 'wp_term_taxonomy' TO 'wpdx_term_taxonomy';
RENAME table 'wp_usermeta' TO 'wpdx_usermeta';
RENAME table 'wp_users' TO 'wpdx_users';

1

SELECT REPLACE(option_name, 'wp_', 'wpdx_') FROM wpdx_options;

1

SELECT REPLACE(meta_key, 'wp_', 'wpdx_') FROM wpdx_usermeta;