Tag: database

  • Why Some WordPress Plugins Leave Orphaned Tables in the Database

    Why Some WordPress Plugins Leave Orphaned Tables in the Database

    Reviews of WordPress plugins on the directory come in all shapes and sizes. Some are really helpful while others are short and to the point. For example, this review from a recent WP eCommerce user, “I uninstalled and it left orphan tables I now have to clean up manually. Poorly done.” This type of review…

  • Delicious Brains Publishes In-depth Guides on The WordPress Database

    Delicious Brains Publishes In-depth Guides on The WordPress Database

    Delicious Brains, the creators of WP Migrate DB, published a guide that walks developers through the WordPress database. The guide describes every database table and there associated columns within WordPress single site. It also features an entity relationship diagram that explains the relationships between the various tables. Although the image was created for WordPress 3.8,…

  • Database Migrations Made Easy Thanks To The WP DB Migrate Plugin

    WP DB Migrate is an awesome plugin created by Brad Touesnard. This plugin makes it easy to transfer the database contents between WordPress powered sites. While there is a Pro version of this plugin available, my experience was with the free version, hosted on the WordPress plugin repository.

  • One Way To Make WordPress Less Portable

    WordPress has a reputation of being very portable but after reading a recent article on WPGarage.com, there is a certain condition in which the data in WordPress can become non-portable. It has to do with the serialization of data. However, they offer up a few different ways in which to deal with the problem so…

  • Bad Comment Karma

    Before making the domain move the other day, I made a mistake by deleting something I shouldn’t have from the database. It was the comment_karma field located within the wp_comments table. A long time ago, I remember installing a plugin called Comment Karma which enabled visitors to rate a comment up or down thus promoting…

  • Plugin Style Settings – Database Or CSS?

    Today I wanted to talk about a problem which Justin Tadlock will be covering in more detail at some point in the future and that is, plugins which contain a CSS file to edit their style. Don’t get me wrong, Lester Chen is a great plugin author, but I find it increasingly annoying that after…