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.
- 6 Best Client Database and Customer Database Software - May 7, 2021
- 8 Best WordPress Firewall Plugins for Security & Protection - May 6, 2021
- 8 Highest Rated WordPress Themes in 2021 - May 4, 2021