Archive for 'web development'

Maintain Unmanaged VPS – Part 7: Reinstate MySQL DBs with Terminal Shell

mysql database import command line image

This guide provides the syntax for uploading data to a MySQL database. For instance, you've changed Linux server, have added a blank database and now want to add your previously backed up data.

Just replace the name of the database, the database username & the password with your chosen options, pasting the code into your terminal.

(Sure, you could use a ...

read more →

Maintain Unmanaged VPS – Part 6: Backup a MySQL Database from the Terminal

mysqldump command line code image

This guide shows how to save a MySQL database using a terminal, with a simple syntax command. And faster than using phpMyAdmin, for sure.

Just replace the db name, username and password and paste the code into your terminal.

While this is a handy how-to, probably you'll want ...

read more →

Maintain Unmanaged VPS – Part 4: Create or Bin MySQL DBs using the Terminal

mysql create database command line image

This how-to guide maps out two pretty basic but handy MySQL operations, creating and binning a database, using the terminal interface.

Sure, you can do those with, say, phpMyAdmin, but it's way quicker to perform such functions using the command line.

Having logged into MySQL's shell using ...

read more →

Maintain Unmanaged VPS – Part 2: Adding Sub-Sites with Nginx

create a-record image

Create sub-sites or prefixed WordPress blogs quickly & easily. Just create an A record, add a vhost file & symlink and restart Nginx.

This is very similar to adding a domain, which is detailed here and cheat-sheeted here, ...

read more →

Maintain Unmanaged VPS – Part 1: Add Web Sites Nginx Cheatsheet

web sites folder structure image

Create additional sites & blogs quickly & easily. After creating the DNS entries, just add a vhost file, its symlink, restart Nginx and go play.

OK. So I did this guide already, already! But as this is one of the main things people do with a VPS – adding extra domains – I figured it wouldn't hurt to provide a shortcut cheatsheet too, minus ...

read more →


a pint of beer

When I started this series I figured I'd cover it in maybe 7 or 8 posts.

I had more hair in those days, and you were younger too.

Apart from underestimating the subject, fact is, with the intended audience for the Bible being Linux and/or VPS newbies, I'd kind of pinned my hopes on uncovering some way to use a control ...

read more →

Maintain Unmanaged VPS – Part 5: Get phpMyAdmin Working with Nginx

phpMyAdmin logo image

How to install PMA with Nginx, to administer multiple MySQL dbs from anywhere. View table structure, browse data, run queries, backup and more.

Adding phpMyAdmin to the Nginx web server is very like adding a sub-site. Dead easy! The process takes 10 minutes, tops. This guide shows you how to add the client, configure a virtual host file with ...

read more →

Set Up Unmanaged VPS (4 Newbies) – Part 19: Moving Day! How to Move Your Blog or Site

server rack in a web data center

Migrate your web site or blog to a new server with minimal problems or inaccessibility. This guide steps out a proven relocation procedure.

When I moved my site from my shared host to my shiny new VPS at Linode, this was a concern for me, particularly as I had a continually changing ...

read more →

Guvnr Gets Steroids – Pursuing The Holy Grail of Less HTTP Requests

a website image sprite for faster loading pages

An often overlooked blog or web site improvement is reducing HTTP requests. Good for page load, improved usability, SEO and ultimately for traffic.

Normally I wouldn't bother writing a post about a site update but, begorrah, I'm so chuffed with Guvnr's new mechanics that ...

read more →

Set Up Unmanaged VPS (4 Newbies) – Part 18: Google Apps for Domain-Specific Email

Google Apps logo image

Easily configure GA's Standard Edition for webmail, plus POP and IMAP email delivery to your desktop mail client.

Whether you want this as a standalone email solution, else to compliment your shared, virtual private or dedicated server, GA saves buckets of ...

read more →
Page 3 of 6 12345...»