In this experiment, we will import Apache’s access logs into the database and do SQL Query to filter the log contents.
sql
Scanning WordPress Database for Specific Meta Values and Options
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.
List out all MySQL Tables by their prefix names
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, […]