How to Import – Export WordPress Database using WP-CLI | WP-CLI | WordPress

I’ve made a video for this tutorial. Because that’s the easiest way to show how we can use WP-CLI to import/export database.

And if you like the video then subscribe my channel and share this with others who want to learn WordPress.

Make WordPress Development soooo easy using WP SCAFFOLD COMMAND | WordPress | WP-CLI | WordPress Development

Check out my new video premiering on 29th Jul 2020 at 10:00 AM IST to Make WordPress Development soooo easy using WP SCAFFOLD COMMAND.

Enable reminder for the premiere so that you won’t miss the video.

SUBSCRIBE THE CHANNEL NOW: https://lnkd.in/gs3i6Me

 

 

How To Create Custom Widget In WordPress VERY EASY | WordPress | WordPress Development

Check out my new video premiering on 28th Jul 2020 at 9:45 AM IST for how to create a custom widget.

Enable reminder for the premiere so that you won’t miss the video.

SUBSCRIBE THE CHANNEL NOW: https://lnkd.in/gs3i6Me

 

Basic Usage of WP-CLI in your WordPress Development | WordPress | WP-CLI | WordPress Development

Check out my new video premiering on 23rd Jul 2020 at 12:15 PM IST for the basic usage of wp-cli in your daily WordPress development process. In this video, I showed only some of the commands which I use on a daily bases.

Enable reminder for the premiere so that you won’t miss the video.

SUBSCRIBE THE CHANNEL NOW: https://lnkd.in/gs3i6Me

 

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;"