Command, File Operations, General

Use RSYNC to backup Remote files to Local folder

Use following command to copy-backup files from remote location to local location. {“/dev/“,”/proc/“,”/sys/“,”/tmp/“,”/run/“,”/mnt/“,”/media/*”,”/lost+found”}: This will exclude the files that we don’t need the backup for. root@111.2222.333.444/path/to/remote/folder/ : This is remote path. /backups/local/folder : This is local path.

Command, Gearman

Install and use Gearman

Queuing systems are complex in nature and developing them is equally a difficult task. Every programming language has to have some sort of queue system to perform certain tasks. So, here we are going to implement a queue system in PHP by using Gearman PECL Extension. Installing Gearman Use the following command to install Gearman package on the centos server.…

Continue Reading

Command, HowTo

Youtube-dl commands

Youtube-dl is a pretty much goto solution for many users to download content from youtube, whether they want to backup their youtube channel content or want to download music youtube-dl covers all. Following are some widely used youtube-dl commands. Get youtube link information without downloading it The following command will get video link information (for example video title or duration)…

Continue Reading

Command, Fix, MySql

MYSQL: Syntax error or access violation: 1055

So upgraded mysql to new version and started seeing these warnings: PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘db.column_name’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible Method 1: We can fix it by…

Continue Reading

General

Centos vs Ubuntu

Following simple 5 point table show how CentOS and Ubuntu are compared to each other. Features Centos Ubuntu Package Command RPM & Yum APT-GET Variant Based on Red Hat Enterprise LinUx (RHEL) Based on Debian Percentage of websites using 17.5% 38.2% Release Cycle Long Period Short Period Security Secure out of the box Less secure compared to CentOS Download Link…

Continue Reading