In this experiment, we will import Apache’s access logs into the database and do SQL Query to filter the log contents.
Most of your WordPress’s configurations reside at Meta Data and Options tables, namely: wp_commentmeta, wp_postmeta, wp_termmeta, wp_usermeta and wp_options.
Filtering on numerous list of MySQL tables is often fun, not just tedious. I am explaining here how to get a list of tables within a database by their prefix names. This method can be further useful when you want to operate an action on list of those tables; like changing their storage engine or, […]