wordpress 이전

사이트 평가

hestia\search.php
template-parts\content.php
hestia\inc\views\blog\class-hestia-blog-post-layout.php

https://developers.google.com/speed/pagespeed/insights/
https://tools.pingdom.com

이미지 cdn으로 옮기기

select * from copy01.wp_posts
where post_content like '%http://onesixx.com/wp-content/uploads/2016/02/%'

select * from copy01.wp_posts
where guid like '%http://onesixx.com/wp-content/uploads/2016/02/%'
and post_mime_type like 'image/%'


update onesixx.wp_posts
set post_content=replace(post_content,'http://onesixx.com/wp-content/uploads/2016/02/','http://onesixx.cdn3.cafe24.com/wp-content/uploads/2016/02/')
where post_content like '%http://onesixx.com/wp-content/uploads/2016/02/%'


update onesixx.wp_posts
set guid=replace(guid,'http://onesixx.com/wp-content/uploads/2016/02/','http://onesixx.cdn3.cafe24.com/wp-content/uploads/2016/02/')
where guid like '%http://onesixx.com/wp-content/uploads/2016/02/%'
and post_mime_type like 'image/%'

--  Actual parameter values may differ, what you see is a default string representation of values
UPDATE wordpress.wp_options
SET option_value='http://localhost/wordpress'
WHERE option_name='siteurl';

UPDATE wordpress.wp_options
SET option_value='http://localhost/wordpress'
WHERE option_name='home';




option_name = 'ossdl_off_cdn_url'


UPDATE copy01.wp_posts
SET guid = replace(guid, 'http://onesixx.com/', 'http://localhost/copy01/');



select * from copy01.wp_posts
where post_title like '%copy%';

---------------------------
SELECT *
FROM one.wp_posts
where post_content like '%아주아주 정확할 필요가 없다면%';


UPDATE one.wp_posts
SET post_content = replace(post_content, '<pre class=\"lang:r decode:true  \">',
'<!-- wp:syntaxhighlighter/code {\"language\":\"r\"} --> 
 <pre class=\"wp-block-syntaxhighlighter-code\">')
where id =15752


UPDATE one.wp_posts
SET post_content = replace(post_content, '</pre>',
'</pre>
<!-- /wp:syntaxhighlighter/code -->')
where id =15752


UPDATE one.wp_posts
SET post_content = replace(post_content, '>','>')
where id =15752



select * from wp.wp_posts
where guid like '%57bf%'

select * from onesixx.wp_posts
where post_content like '%http://onesixx.com/wp-content/uploads/2015/%'


select * from onesixx.wp_posts
where guid like '%http://onesixx.com/wp-content/uploads/2015/01/%'
and post_mime_type like 'image/%'


update onesixx.wp_posts
set post_content=replace(post_content,'http://onesixx.com/wp-content/uploads/2016/','http://onesixx.cdn3.cafe24.com/wp-content/uploads/2016/')
where post_content like '%http://onesixx.com/wp-content/uploads/2016/%'


update onesixx.wp_posts
set guid=replace(guid,'http://onesixx.com/wp-content/uploads/2016/','http://onesixx.cdn3.cafe24.com/wp-content/uploads/2016/')
where guid like '%http://onesixx.com/wp-content/uploads/2016/%'
and post_mime_type like 'image/%'