First of it all, login to your phpmyadmin and choose your WordPress database. Once done, click on the sql button to open the sql command window.
Then, simply paste the following sql command and execute it.
DELETE FROM `wp_options` WHERE `option_name` LIKE ('%_transient_%');
Credit: Stack Overflow
Want more super useful SQL queries? Check out this article on Cats Who Code.
The post Downsize your WordPress database by removing transients appeared first on WPRecipes.
What’s My SEO Score?
Enter the URL of any landing page or blog article and see how optimized it is for one keyword or phrase.
Latest posts by WordPress Expert (see all)
- GetResponse Review: Is It Worth It? (Features, Pricing, and Alternatives) - January 28, 2022
- 9 Top Zoho Alternatives that are Worth Their Money - January 27, 2022
- How to Fix “This account has been suspended” Message - January 25, 2022