Edit a page/post DB data?

There is no built-in way to directly edit the database data for a page or its revisions in WordPress. However, you can achieve this by using a plugin such as WP-DB Manager, which provides a user-friendly interface for managing and editing your WordPress database. This plugin allows you to directly edit the database data for … Read more

Database Queries are crashing the server

It seems like you’re experiencing slow queries after migrating your website to Hostinger. The query you provided is an update statement for the wp_options table in a WordPress site. This query appears to be related to the Freemius API, which is a monetization platform for WordPress plugin and theme developers. Here are some steps to … Read more

Change permalinks in posts via SQL

If you are using MySQL 8 and above you can use REGEXP_REPLACE, e.i. UPDATE `wp_posts` SET post_content=REGEXP_REPLACE(post_content, ‘domain.tld\/[0-9]{4}\/[0-9]{2}\/[0-9]{2}\/’, ‘domain.tld/’) WHERE post_content REGEXP ‘domain.tld\/[0-9]{4}\/[0-9]{2}\/[0-9]{2}\/’; this would look for exact match domain.tld/{4 digit int}/{2 digit int}/{2 digit int}/ then replace it with domain.tld/ so it will replace something like domain.tld/2000/01/01/my-cool-post/ to domain.tld/my-cool-post/ Another option if you cannot … Read more