Database backup or porting is an important activity for many of the developers. If you forgot to take up-to date backup of your whole databases; run the script similar as below. Change your username, password to root’s credentials.
gist
Testing PHP.ini configurations with PHPUnit
Why should we limit use of PHPUnit to test the features we built only? Some failures are often due to server side configuration errors in php.ini file. My effort here is to ensure that the server always runs under your specific consideration.
Importing Apache’s Access Logs into MySQL
In this experiment, we will import Apache’s access logs into the database and do SQL Query to filter the log contents.
What is micro-optimization?
Sometimes, there are chances that if you make a bit of changes in your source code, it performs faster by a fraction of a second. This does not seem always logical for small projects to spend time in optimization. But when several users load your website at once, micro-optimization can contribute to the speed.
XDebug: Optimal Personal Configurations
I initiate XDebug on demand, via URL parameters. But XDebug configurations in php.ini has to be configured accordingly to accept those requests and obey them. Thus, only the scripts that need debugging or tracing or profiling will request the particular service. Keeping memory and CPU free is also important.
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, […]
Database of PHP Defined Constants
How many inbuilt constants are there in PHP? Several? Near to thousand? This experiment is to build a MySQL Database of PHP Constants.
HCI – Hosted Content Importer for WordPress
Tired of static content in the blogs? Here is something new – my HCI plugin. It will fetch the content programmatically for the given Post IDs in WordPress or Remote Content IDs.