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.
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.
In this experiment, we will import Apache’s access logs into the database and do SQL Query to filter the log contents.
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.
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.
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, […]
How many inbuilt constants are there in PHP? Several? Near to thousand? This experiment is to build a MySQL Database of PHP Constants.
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.