Spent a few hours tugging with the WordPress database. \u00c2\u00a0It seemed like a good time to move the database into a more recent version of MySQL.<\/p>\n
It should have been pretty easy. \u00c2\u00a0Create the new \u00c2\u00a0table space, define, and load the tables. \u00c2\u00a0Tell WP where to look for the data base, and done. A snap, right?<\/p>\n
Not so fast SQL-breath! All of the data appeared to load properly, and WP came up as it should. \u00c2\u00a0The problem was some junk data interspersed within the text of most every post.<\/p>\n
Here was the tricky part. \u00c2\u00a0I generally use Notepad++ for general plain test editing. It is a really nice programmer’s text editor. \u00c2\u00a0 But it wasn’t displaying the junk characters embedded within the text. Grrrrr.<\/p>\n
But Notepad++ can also convert the text files code type from ASCII to UTF, etc, etc. \u00c2\u00a0 From one platform to another, sometimes “plain text” turns out to be not so plain. \u00c2\u00a0But by using the various different text encoding formats, I was finally able to display the junk data. And get rid of it.<\/p>\n
After that, everything looks pretty good now. \u00c2\u00a0Also settled on the google translation widget. \u00c2\u00a0Folks seemed to use it more often, and I’ve been told it gives the more useful translations.<\/p>\n","protected":false},"excerpt":{"rendered":"
Spent a few hours tugging with the WordPress database. \u00c2 It seemed like a good time to move the database into a more recent version of MySQL.<\/p>\n
It should have been pretty easy. \u00c2 Create the new \u00c2 table space, define, and load the tables. \u00c2 Tell WP where to look for the data base, and done. A snap, right?<\/p>\n
Not so fast SQL-breath! All of the data appeared to load properly, and WP came up as it should. \u00c2 The problem was some junk data interspersed within the text of most every post.<\/p>\n
Here was the tricky part. \u00c2 I generally use Notepad++ for general plain test editing. It is a really nice programmer’s text editor. \u00c2 But it wasn’t displaying the junk characters embedded within the text. Grrrrr.<\/p>\n
But Notepad++ can also convert the text files code type from ASCII to UTF, etc, etc. \u00c2 From one platform to another, sometimes “plain text” turns out to be not so plain. \u00c2 But by using the various different text encoding formats, I was finally able to display the junk data. And get rid of it.<\/p>\n
After that, everything looks pretty good now. \u00c2 Also settled on the google translation widget. \u00c2 Folks seemed to use it more often, and I’ve been told it gives the more useful translations.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[11],"tags":[],"_links":{"self":[{"href":"http:\/\/w4kaz.com\/qth\/index.php?rest_route=\/wp\/v2\/posts\/1172"}],"collection":[{"href":"http:\/\/w4kaz.com\/qth\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/w4kaz.com\/qth\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/w4kaz.com\/qth\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/w4kaz.com\/qth\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1172"}],"version-history":[{"count":5,"href":"http:\/\/w4kaz.com\/qth\/index.php?rest_route=\/wp\/v2\/posts\/1172\/revisions"}],"predecessor-version":[{"id":1177,"href":"http:\/\/w4kaz.com\/qth\/index.php?rest_route=\/wp\/v2\/posts\/1172\/revisions\/1177"}],"wp:attachment":[{"href":"http:\/\/w4kaz.com\/qth\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/w4kaz.com\/qth\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1172"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/w4kaz.com\/qth\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}