Plesk MySQL Daily Backup Script

Create file With the following content If you need multiple copies of MySQL database kept, use https://gist.github.com/serverok/5a247a5b8485a6a29764f12118a7f727 Make it executable

cronjob

crontab Start a program after reboot using cronjob Running wp-cron with cronjob Cronjob for Magento 1.9 set vi as default

Language

perl: warning: Falling back to a fallback locale (“C.UTF-8”). sudo apt-get install locales-all dpkg-reconfigure locales On a Linux server, if

cut

How to cut lines separated by multiple spaces? Here is an example of cut command, that will remove all PHP

apt

List all Dependencies for a package. If you don’t want to upgrade a package, you can use apt-mark command to

MySQL User

Create a user For local mysql access CREATE USER ‘USERNAME-HERE’@’localhost’ IDENTIFIED BY ‘PASSWORD_HERE’; GRANT ALL PRIVILEGES ON DB_NAME_HERE.* TO ‘USERNAME-HERE’@’localhost’;

Enable FCGI cache in Nginx

To enable fcgi cache in Nginx, add the following code outside the server block. fastcgi_cache_path /var/run/nginx-fastcgi-cache levels=1:2 keys_zone=SOKCACHE:60m inactive=60m; fastcgi_cache_key

MongoDB

MongoDB is an open-source NoSQL database. https://www.mongodb.com Connecting to MongoDB with user/pass Install MongoDB Backup MongoDB Free MongoDB hosting

Rsync backup with X days retention

rsync is run on backup server, that login to remote servers and backup. vi /usr/serverok/rsync-backup.sh Add following code #!/bin/sh date

lvm

vgcreate pvdisplay lvdisplay lvcreate Resize EC2 file system with LVM pvcreate Device /dev/sdb excluded by a filter How to Remove

Nginx WordPress

Here is nginx configuration for wordpress server { listen 80; server_name serverok.in www.serverok.in; root /var/www/html; index index.php; client_max_body_size 100M; location

Cpanel Error NetworkManager is installed

When installing Cpanel on a dedicated server, i get error NetworkManager is installed and running, or configured to startup. To