shopify analytics ecommerce

Monthly Archive: May 2015

[Perl Script] — Backup MySQL

This is a MySQL backup tool written by Perl, please modify the follow variable for your setting: $db_username: mysql username $db_password: mysql password $db_host: mysql server hostname $mysqldump: mysqldump path $backup_dir: path ofsave backup files $rotate: number of backup copy keep @backup_db: backup …

MySQL Backup Shell Script

This is the Shell Script for backup MySQL database, it will use mysqldump create backup files and use gzip compressing to .gz files. This script will save 5 days backup and able to auto rotate. Usage: Modify db_user, db_passwd and db_host to your …

RHEL / CentOS install MRTG

MRTG (Multi Router Traffic Grapher) is a traffic monitoring tools based on SNMP protocol, this is the steps of install MRTG on RHEL and CentOS 1. Install MRTG: # yum install mrtg net-snmp net-snmp-utils 2. Setup SNMP: edit /etc/snmp/snmpd.conf and add this line: …

Sudo without password

This is the steps for setup sudo without password: 1. run visudo edit sudo config file: # sudo visudo 2. e.g. if the user is user123, find this line: user123 ALL=(ALL) ALL change to user123 ALL=NOPASSWD: ALL save and exit, next time when …