the nameservers switched over sometime this morning!
\nthe blog is back online!!<\/p>\n
in the process i lost one database. and i didn’t really lose it proper, but rather decided to simply let it fade into the ether. i’ll likely re-establish it at some point in the near future, but i have to think further about its importance, purpose, message, etc. it was the fluxphblog, for those who followed that project.<\/p>\n
so getting the blog back to full wasn’t as easy as it is<\/a> made out to be<\/a>. of course, i kind of know why.<\/p>\n in the process of restoring the database tables, there was a feature that didn’t get properly re-implemented nearly 8 or so times. this feature, called ‘AUTO_INCREMENT’ is pretty important, because it tells various functions that WordPress<\/a> performs, to automatically go to the next number; i.e. this is post #65, so the next one would be #66, and so forth.<\/p>\n first off recognizing that there was a problem, and then finding the right group of words that others might have reported for the same problem, took a couple of hours before i stumbled upon the ‘auto_increment’ suspect. then having to search this further, and find how others might go about fixing it, all took too long.<\/p>\n but i reckon i know why this problem emerged in the first place: my previous host was running MySQL<\/a> 4.1.11, and my current host, while ‘better’ so far, is running an older version of MySQL, v3.23. when i migrated the database, i told the exported database to become 3.23 compatible, but with such a drastic move, any number of variables could have caused the drop. oh well, lesson learned!<\/p>\n the tables seem solid now, after all, i’m posting again!<\/p>\n WordPress support pages that helped me solve the ‘AUTO_INCREMENT’ bug:<\/em> the nameservers switched over sometime this morning! the blog is back online!! in the process i lost one database. and i didn’t really lose it proper, but rather decided to simply let it fade into the ether. i’ll likely re-establish it at some point in the near future, but i have to think further about […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[2],"tags":[5,52],"series":[],"class_list":["post-25","post","type-post","status-publish","format-standard","hentry","category-normalblog","tag-about-the-blog","tag-wordpress"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p6OfVu-p","_links":{"self":[{"href":"https:\/\/www.nicknormal.com\/normalblog\/wp-json\/wp\/v2\/posts\/25","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nicknormal.com\/normalblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nicknormal.com\/normalblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nicknormal.com\/normalblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nicknormal.com\/normalblog\/wp-json\/wp\/v2\/comments?post=25"}],"version-history":[{"count":1,"href":"https:\/\/www.nicknormal.com\/normalblog\/wp-json\/wp\/v2\/posts\/25\/revisions"}],"predecessor-version":[{"id":2508,"href":"https:\/\/www.nicknormal.com\/normalblog\/wp-json\/wp\/v2\/posts\/25\/revisions\/2508"}],"wp:attachment":[{"href":"https:\/\/www.nicknormal.com\/normalblog\/wp-json\/wp\/v2\/media?parent=25"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nicknormal.com\/normalblog\/wp-json\/wp\/v2\/categories?post=25"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nicknormal.com\/normalblog\/wp-json\/wp\/v2\/tags?post=25"},{"taxonomy":"series","embeddable":true,"href":"https:\/\/www.nicknormal.com\/normalblog\/wp-json\/wp\/v2\/series?post=25"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n[resolved] New Host , Restore database<\/a>
\nAdmin breaks if post or category ID == 0<\/a>
\n“Write Post” page appears blank in 2.0.3<\/a><\/p>\n