How to backup MySQL to FTP

Here is a simple script to backup MySQL databases via FTP: Re-reqs – in this case I used ncftp as the client: apt-get install ncftp Create and open a new Backup Script: vim /path/to/backupscript.sh Insert the following code: #!/bin/bash #Variables FILENAME=/backup/$(date +%d%m%Y).sql FTPHOSTNAME=”host” FTPUSERNAME=”ftpuser” FTPPASSWORD=”ftppassword” MESSAGE=”Database Backup Successful” #SQL VARIABLES SQLUSERNAME=”sqluser” SQLPASSWORD=”sqlpassword” DATABASE=”sqldatabase” #SQL BACK […]

How to upgrade Debian 6 squeezy to Debian 7 wheezy

Make sure to backup all your data before doing this, always backup backup backup! Update your sources.list: vim /etc/apt/sources.list Add the following sources: deb http://mirrors.kernel.org/debian/ wheezy main deb-src http://mirrors.kernel.org/debian/ wheezy main deb http://security.debian.org/ wheezy/updates main deb-src http://security.debian.org/ wheezy/updates main # wheezy-updates, previously known as ‘volatile’ deb http://mirrors.kernel.org/debian/ wheezy-updates main deb-src http://mirrors.kernel.org/debian/ wheezy-updates main Update the […]

How to password protect a directory with .htaccess

To protect a directory on the web follow these simple steps: 1. Open a .htaccess file within the directory you wish to protect vim .htaccess 2. Insert the followoing code: AuthUserFile /route/to/directory/.htpasswd AuthGroupFile /dev/null AuthName “Custom text to show in pop-up” AuthType Basic <Limit GET> require valid-user </Limit> 3. Now we need to create the […]

How To Optimize Linux For SSDs

Get the most out of your SSD in Linux – here’s what you need to know. Linux is pretty great out-of-the-box, there are still some items that require a little bit of manual optimization to get them going as smoothly as possible. Controlling power consumption is the most common one, but optimizing your system for SSDs is […]

How to Create Custom Post Types in WordPress

Over the past years, WordPress has evolved into a robust content management system. By default WordPress comes with post and pages as the main content types. However you can create as many custom content types as you like, and these custom content types are referred to as Custom Post Types. In this article, this guide will show […]

How to Add Social Buttons in WordPress RSS Feed

While most modern feed readers include social sharing capabilities, in this article, we will show you how to add social buttons in WordPress RSS feed. First thing you need to do is download the social buttons you would want to display in your feeds. There are several social media icon sets available for free. Choose […]

NGINX – Allow access only to certain IPs

Nginx has a nice module that not many people know about, it basically enables us to allow or deny access to directories served by the webserver. The module is named ngx_http_access_module to allow or deny access to IP address. The syntax looks like this: location / { deny 192.168.1.1; allow 192.168.1.0/24; allow 10.1.1.0/16; allow 2001:0db8::/32; deny all; } The […]

How to configure a PPTP connection in Windows 7

Windows 7 PPTP VPN Client Setup Let’s talk about Windows 7 PPTP VPN client setup in this article, so that you can connect to your home or company’s PPTP VPN server later. In addition, you can also use this VPN client to connect to VPN server that supports L2TP/IPSec, SSTP or IKEv2 VPN protocol. Without wasting more […]

ownCloud Auto Install Script on Debian 7

Here is an easy way to install ownCloud on Debian 7 with a script, but first, for those who don’t know what ownCloud is: ownCloud is a free and open-source web application for data synchronization, file sharing, and cloud storage. ownCloud is written in the PHP and JavaScript scripting languages. For change management, it employs […]

How to Install a Proxy using SQUID3 on Debian 7

This tutorial is to show you how to install a proxy on Debian 7 using SQUID3 In order for this to work correctly you will need to follow these instructions.   #!/bin/bash # ©2013-14 Mark Mearns. All Rights Reserved. # This script is distributed under a Creative Commons ShareAlike 3.0 licence. # http://creativecommons.org/licenses/by-sa/3.0/ clear echo […]