wordpress-avada，修改域名及存储路径 sql脚本

修改域名：use wordpress;

—

修改表wp_posts：

update wp_posts set guid = replace(guid,'old_url','new_url') where guid is not null;

update wp_posts set post_content=replace(post_content,'old_url','new_url') where post_content is not null;

— 修改表wp_options：

update wp_options set option_value = replace(option_value,'old_url','new_url') where option_value is not null;

————————————————————————————————————————————-

修改存储路径：update wp_options set option_value = replace(option_value,'D:\phpStudy\WWW/','new_url') where option_name='recently_edited';