Let’s talk about resets

I had to do one larger one, so I’ll give you the full list. This is basically an undo.

On Tumblr:

I had to undo the rename of my tumblr, and went back to Code & Canvas.

Used XKit Rewritten to replace the tag “mario breskic” with “code and canvas” for my posts.

On social.mariobreskic.de:

Renamed the “mario breskic” tag to “code and canvas” in WordPress.

Replaced the links to mario-breskic.tumblr.com with codeandcanvas.tumblr.com using phpMyAdmin

UPDATE wp_posts SET post_content = REPLACE(post_content, ‘mario-breskic’, ‘codeandcanvas’) WHERE post_content LIKE ‘%mario-breskic%’;

Replaced the string “Mario Breskic” with “Code & Canvas” but only in posts tagged “code and canvas” using phpMyAdmin

UPDATE wp_posts p
JOIN wp_term_relationships tr ON p.ID = tr.object_id
JOIN wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
JOIN wp_terms t ON tt.term_id = t.term_id
SET p.post_content = REPLACE(p.post_content, ‘Mario Breskic’, ‘Code & Canvas’)
WHERE p.post_type = ‘post’
AND t.name = ‘code and canvas’
AND p.post_content LIKE ‘%Mario Breskic%’;

Struck the previous changes from my changelogs on my websites and added a note that I have done so.

Made link changes on my homepage and on my bento.me, too.

Same with other socials with more link options, like Artstation, Bēhance, Facebook.

I used an AI (Copilot) to write the SQL for me.

All in all, this should get me to at least 80% of the reset. There might be something I’ve overlooked but this is alright for now.

As resets go, this one has been smooth.

I think I’ll grab a splatbook and sit down with a cup of caffeine‑free coffee.

Source: My after‑hours blog on Tumblr Code & Canvas

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *