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