The only things you could clear out like this are transients, temporary options in the database. WP already does this on a cron job, and it’s unlikely to have a big impact. If you don’t mind data loss, revisions might reduce the database size, but that’s highly dependent on what you’ve been doing with the database.
A lot of the generated data WP uses is generated in realtime, e.g. post type data is registered on every page load as it’s cheap and fast. Cached data lives in memory and gets erased when the page has finished loading, or it persists in an object cache where it has a limited lifespan but doesn’t touch the database.
Eitherway, this is not the approach to take, and is a dead end not worth exploring. You’ll get a lot more out of zipping up your backups, or investigating incremental backups instead, but that’s a database question not a WP question.
Related Posts:
- What’s the simplest way to backup my WordPress database?
- Does wpdb add considerable overhead on queries with large result sets?
- Faulty restore of the database, encoding issue
- WordPress and automated MySQL backups to a different host
- Backup another database with BackUpWordPress plugin [closed]
- Why are no posts showing despite my apparently correct DB restoration?
- What happens if I overwrite the current wp_options table with a backup from a week ago?
- Why does importing copies of the database dump and the document root make WordPress data inconsistent?
- Store partial database to an archive database time to time
- Where is phpMyAdmin inside WordPress?
- How To Run A Temporary Instance Of a WordPress Backup Without a Database?
- How to backup my site and restore my wordpress site
- Cannot restore wordpress database from sql dump [closed]
- wordpress database restore – broken link
- restore a db after bad backup
- Backing up WordPress database and files
- How can i restore a WordPress site with the DB and WordPress Files
- How do you enable scripts on a WordPress installation in Softaculous?
- SQL database import #1046 error
- is it possible to install new WordPress in an old WordPress folder?
- Is it possible to separate databases in WordPress site – one for orders and the other for all non-orders related
- WPCLI search and replace in a particlar site dir effect another site-dir
- How do I find out from my database what version of WordPress I need?
- Backup Restore turns carriage returns to literal strings
- I have a WordPress 4.6 database dump – how do I use it in a new install?
- Copy WordPress to new directory
- Find/ascertain latest wordpress db from multiple database copies
- version control for wordpress? (wordpress folder and database at same time)
- What’s the cleanest way to transfer WordPress to a new server
- Checking if Database Table exists
- Staging sites, how do you manage synchronising updates in the DB?
- How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
- Using transients in conjunction with memcached
- Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
- Forcing nickname as display_name in custom edit profile template
- Syncing local content with development / staging sites
- Export WP database for import using WP-CLI on Vagrant Box
- Improve or optimize a very slow query
- What is the advantage of separating wp_users and wp_usermeta table?
- Showing content from another wordpress installation database in the page template loop?
- “MySQL server has gone away” since update to 3.8
- WordPress page title repeated in SOME pages
- Why is $wpdb->get_results failing on certain tables but not others (which have data)?
- How to correctly add a table to the WordPress MySQL database
- MySQL Syntax Error upon restoring database from backup [closed]
- Help running a MySQL query to update all wp_#_options tables in a Multisite install
- How to verify password outside WordPress?
- Is it safe to convert tables from MyISAM to InnoDB?
- Use one WordPress database with multiple instances of one site
- Who is responsible for data sanitization in WordPress development?
- How do I properly update the WordPress database password?
- wpdb_prepare with multiple or condition
- Automate dir and DB stack creation with WP-CLI
- Moving WP from local server to live, error establishing a db connection
- delete post meta from db, even if does not exist?
- In what part of the WordPress core does the users table and usermeta table get joined?
- WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
- wp search-replace (not executing)
- Create table from array with prepare
- Migrate database between 2 different wordpress version
- SSO system between 2 WordPress installs on different servers
- Form that sends data to an admin panel and can export it
- All text disappeared (seems to be a database problem) [closed]
- Convert user passwords to MD5?
- is wordpress stores Role Id in WP database?
- Why do database examples sometimes finish with an add_option call?
- Does post_meta data need to be unserialzed?
- How and where is wordpress adding mySQL content to database?
- How get Data form wordpress database as array not stdclass?
- cannot connect database
- How to delete a particular row in a database table
- Brandoo WordPress Unable to Update to WordPress 4.2.2
- Connecting to wordpress database in my application [closed]
- Custom Post Type not showing anything added by code anymore?
- How do I have a user upload a blog post and then retrieve that to display in a card on the site?
- Delete user with only subscriber role
- WordPress keeps redirecting to localhost
- get value from ‘terms’ table
- custom tables in wordpress Database? (can i just create them with sql?)
- How to rename custom table name programatically in wordpress?
- Displaying requested data from a the database in wordpress
- How to edit custom table data in frontend
- pre_get_posts causings DB error when using ( ‘posts_per_page’, -1)?
- generate PDF from member information
- Help posting values to DB on submit using $wpdb->query
- wpdb query to insert images in to post/page gallery
- Creating a database in my plugin not working
- How to create index (sql) to a meta_key?
- Not sure what to do next to optimize
- get_user_meta and umeta_id
- $wpdb not working
- Accessing content from third party as native posts in WordPress
- Send data to database after redirect (and popping out of iframe)
- Fetch data from another site, but the same database
- Simple email input store in database
- $wpdb->insert not working for last select option
- How to create a table [closed]
- Upload wordpress from localhost to 000webhost
- SQL query to rewrite all media URLs to end with .webp
- Many images in wp-content/uploads folder that are not in Media Library