The plan here is to allow you to have dual booting operating systems; where you will be able to “reuse” same copy of your database files and web scripts; regardless of what operating system you are in. Audience: Mid to Expert web developer with experiences on Linux Shell Scripting and Apache, MySQL Administration. Follow these […]
mysql
Helper plugin for Troubleshooters: My-Tables
How many records do you have in each WordPress database tables? My-Tables plugin might be helpful for you troubleshooting your issues over there.
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.
Commenting MySQL Table Names
Commenting your tables is an important activity, when you have larger number of tables, or table names do not necessary indicate the purpose of their usage.
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, […]