This is moved to https://bhargavb.com/how-to-import-export-wordpress-database-using-wp-cli-wp-cli-wordpress/
Tag: wp-cli
Make WordPress Development soooo easy using WP SCAFFOLD COMMAND | WordPress | WP-CLI | WordPress Development
How To Create Custom Widget In WordPress VERY EASY | WordPress | WordPress Development
Basic Usage of WP-CLI in your WordPress Development | WordPress | WP-CLI | WordPress Development
Check the largest value of autoload filed in options table
Below query can help you to find which field contains the largest value of autoload field in options table.
SELECT option_name, LENGTH(option_value), autoload FROM wp_options WHERE autoload = 'yes' ORDER BY `LENGTH(option_value)` DESC
NOTE: change your table prefix as per your site.
WP-CLI:
wp db query "SELECT option_name, LENGTH(option_value), autoload FROM wp_options WHERE autoload = 'yes' ORDER BY LENGTH(option_value) DESC;"




