Not a hard task at the end. I’ve managed to do it in two chunks with
UPDATE wp_options SET autoload = 'no' WHERE option_name LIKE 'category%'; and
UPDATE wp_options SET autoload = 'no' WHERE option_name LIKE '_category%';
Related Posts:
- Should I remove transients from the wp_options table?
- Will it break my site if I delete all transient records in wp_options table?
- WordPress (MyISAM) database is slow, should I switch to InnoDB?
- Please explain how WordPress works with MySQL character set and collation at a low level
- What is the purpose of the option name hack_file in the options table?
- delete_option() and update_option() returning false
- How to change option recently_edited?
- store simple data in get_option()
- WP_Options ID high
- Transient RSS feeds in wp_options not removed automatically?
- Long option names fail silently?
- save new data to wp_options non-post form
- How to solve slow WordPress site caused by attachment_metadata
- Huge wp_options table
- Cannot unserialize WordPress serialized values in `wp_options` table?
- WordPress DB: options-table –> 32 gzipcompression?
- wp_options table has duplicate rows and primary key / autoincrement has been removed
- Help running a MySQL query to update all wp_#_options tables in a Multisite install
- What ALL can cause “Another update is currently in progress.”? [closed]
- I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
- Accidentally deleted active_plugins portion of the wp_options DB table
- Multiple wp_options tables to share content across installs
- Improve performance by removing unnecessary database queries
- Cleanup: best way to remove WooCommerce comments from the wp_comments table
- What would Repair and Optimize WordPress Database do?
- fastest replacement DB
- Is there an atomic way to update_option in WordPress (to ensure data integrity)?
- Does auto_load to ‘no’ in wp_options improve performance
- Check if an option exists and get its value in one hit
- My options table is huge. What can I do?
- Change options table prefix only
- When to use custom DB tables or add_option?
- In which format the data is stored in WordPress Databases?
- Automate WordPress website setup with prefilled data
- Optimizing function that automatically creates internal links based on post title string
- Image link issues after importing a database backup to my local web server
- Native timestamp on wp_options option
- Whats the best practise on how to store json data from a custom settings page?
- Will memcached improve performance with WP Super Cache already running?
- WordPress Settings API Overrides My Previous Value
- What structure and database storage method should I use for temporary storage that may be written concurrently?
- get_option() does unserialize and don’t remove \
- How to optimize wp_option table?
- How to optimise this database query?
- I cannot change anything in my wordpress database from within wordpress?
- Wrong url for the images while using same database for two WordPress installations
- Options table – where does my values go?
- Theme options not being sent to Database
- Multiple Address In WP-Option Value
- How do I use update_option to give me a new option name each time a form is submitted? [duplicate]
- Best way to search and replace within serialized database strings?
- Rename a table in MySQL
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Keeping WP database synced across multiple developers using git
- How to define composite keys with dbDelta()
- Connect forms in WP to external database
- How to get site URL if database is disconnected?
- Is it wise to delete post revisions and autosaves from database?
- Multiple WP install with same users database
- Using two different DB users on one WP install
- Usage of Direct Database Call Without Caching Error
- Can I transfer a mysql database to another site?
- Weird issue with database migration and SSL links
- Backup another database with BackUpWordPress plugin [closed]
- How to use a different database to list and manage comments in the backend
- Error establishing a database connection on Installation
- SQL QUERY – Select a value directly from the database
- Why is it that not all users have a ‘session_tokens’ meta_key record in the usermeta table?
- Output custom content not from the posts table?
- How to have an external DB read and get data from my wordpress database
- restore a db after bad backup
- Best practice to import user base (subscribers) from one website to another?
- Some weird users in database
- Location of image metadata on my server
- How to create more than one new wpdb object?
- Is it good practice to import/export a blog to test a redesign?
- Getting value from database table depending on field value
- Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
- Secure way to use name_save_pre?
- wpdb->insert not inserting first variable
- Database tables for sports betting integrated in WordPress
- change the year on all of my custom post types?
- New installation fatal error in 5.9.3 at edit or create entry
- Storing transients giving database error
- I want to replicate a wordpress website over multiple servers
- Is there anyway to split posts to different databases?
- wp-cli + valet: “Error establishing a database connection”
- local wordpress broke after changing URL
- Unable to login to a https website via the app after changing from http
- Is it safe to add INDEX to a column in WordPress database?
- Restore Old Database Over Newer WP & Plugin Files
- Optimized PHP & WordPress settings for speed/performance?
- Database structure for thousands of posts
- How do I find out from my database what version of WordPress I need?
- How to create a database table?
- Extracted CSV as Array for Custom Query Loop
- Hang Up Followed By Can’t select database
- One WP Database outside localhost and two connections
- Every time I update or install a plugin I get “Error Establishing a Database Connection in WordPress”
- Create hundreds of users with just ID in phpMyAdmin