So ...

A few more things you should know ...

1. If you're noticing timeouts or getting a white screen while running a search and replace task, you can always decrease the max page size option (20000 by default) on the "Settings" tab:

2. In order to efficiently use the plugin, you should have a basic understanding of Wordpress database management ... More exactly, you should know what each table does in Wordpress ...

A regular Wordpress installation has eleven default tables in the database, and each table contains data for different website sections or Wordpress features. In other words, these default tables can help you to understand where different parts of your Wordpress website are stored ... Here they are:

• wp_commentmeta - contains meta information about comments posted on your site; for example, the status of the comment (approved, pending, trash, etc); the table has four fields meta_id, comment_id, meta_key, and meta_value (obviously, each meta_id is related to a given comment_id
• wp_comments - contains your comments with comment author name, URL, email, comment, etc. included
• wp_links - contains links needed to manage blogrolls created by previous Wordpress versions or different link manager plugins
• wp_options - contains most of your site-wide Wordpress settings; options like site URL, admin email, default category, posts per page, time format, etc; additionally, many plugin settings will also be stored in this table
• wp_postmeta - contains meta information about your posts, pages, and custom post types; for example, custom fields, page or post templates, etc
• wp_posts - contains all your posts, pages, custom post types, revisions
• wp_terms - the Wordpress taxonomies are used to organize your content; these individual taxonomy items are called terms and they are stored in this table; for example, your tags and categories are taxonomies, and each category and tag inside them is a term
• wp_term_relationships - manages the relationship of post types with terms in wp_terms table; for example, helps Wordpress to determine the category of a given post
• wp_term_taxonomy - defines taxonomies for terms defined in wp_terms table; for example, helps Wordpress differentiate between which term is a category, which is a tag, etc
• wp_usermeta - contains meta information about your users
• wp_users : contains general user information such as username, password, user email, etc

Note: as I said, many plugins will store their settings in the wp_options table, but that's not a general rule; there are many plugins and sometimes even themes that can and will create additional tables in your Wordpress database. For example the YOAST plugin:

And that's it my friends! If you have any comments, further questions or update requests please don't hesitate to react! Like, comment and share!

Other related tutorials may want to see:

Wordpress glossary for beginners and vets

Blogging glossary for beginners and vets

How to bulk change post categories and tags in Wordpress

Why and how to optimize your Wordpress database

And don't forget, you can easily come back to this tutorial whenever you want.

All you need to do is to bookmark the categorized, daily updated register of my blogs and training materials. Here it is:

Posts and training by smartketeer

Thanks for your time!