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

phpMyAdmin - HTTP error 404
Command, Fix, phpMyAdmin

Fix phpMyAdmin – HTTP error 404

phpMyAdmin – HTTP error 404 appears when the server does not find the default phpMyAdmin folder. This can be fixed if you manually download phpMyAdmin or by running the following command on SSH. Wait for command to finish, then reload phpMyAdmin page that gave error to confirm its working again.