wordpress 修改表前缀

修改配置文件

# wp-config.php
$table_prefix  = 'work_';

挨个修改表名:

RENAME table `w_commentmeta`  TO `work_commentmeta`;

修改表内容

update work_options set option_name = replace(option_name,'work','work_');
update work_usermeta set meta_key = replace(meta_key,'work','work_');