How To Backup Databases Using mysqldump Tool , How to backup a MySQL database , How to backup MySQL database structure only , How to backup multiple MySQL databases into a single file

MySQL GUI tools such as phpMyAdmin, SQLyog and etc, often provide features for backup MySQL databases with ease. However, if your database is big, the backup process could be very slow because the backup file needs to be transferred across the network to your client PC. As the result, the backup process increases the locking... Continue Reading →

WEB CACHE: APC VS MEMCACHED VS VARNISH

With increasing amounts of data and server-side processing, caching systems are as important as ever. There are so many varieties of these systems out there, it can be confusing if you don’t understanding the different nuances. Worse yet, if you pick the wrong caching system for your needs or fail to optimize it correctly, the... Continue Reading →

Query time result in MySQL w/ PHP

$starttime = microtime(true); //Do your query and stuff here $endtime = microtime(true); $duration = $endtime - $starttime; //calculates total time taken This will give you the run time in microseconds.

Type hinting in php

With Type hinting we can specify the expected data type (arrays, objects, interface, etc.) for an argument in a function declaration. This practice can be most advantageous because it results in better code organization and improved error messages.It will also explain the subject of type hinting for basic data types (integers, floats, strings, and booleans)... Continue Reading →

WordPress.com.

Up ↑