Posts Tagged 'db'



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 →
15

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 →
2

Set Up Unmanaged VPS (4 Newbies) – Part 17: Nginx Control Panel Workarounds

nginx control panel image

No viable panel, huh? OK, so we'll use some super-cool workarounds. Every cPanel module is listed here, together with the copy/paste code for the Nginx-equivalent alternate function.

With no feasible control panel module available for the Nginx web server, what's missing? What do we need for virtual private server & domain administration, and to set up and ...

read more →
6

Set Up Unmanaged VPS (4 Newbies) – Part 15: WordPress Setup & Updates from the Command Line

wordpress installed using subversion image

This how-to guide uses Subversion to download & install standalone WordPress blogs & their plugins, quickly and easily from your Linux command line interface, with simple updates thereafter. It also details the WordPress MySQL database setup process.

OK, I admit, I am biased towards WordPress! And this guide is a perfect fit for those wanting to launch their WP ...

read more →
27

Video How-to: 10 Tips To Make WordPress Hack-Proof

secure wordpress image

UPDATE: Sept 2013

This post has turned into a site, possibly the most complete WordPress security site ever produced.

Featuring hundreds of tutorials & forums, check it out: wpCop: Secure WordPress. Properly.

guv

Securing WordPress isn't this easy!

Yeah, sorry to break it to you but, having spent the last couple of years immersed ...

read more →
134

Video How-to: Backup & Restore a Database with phpMyAdmin

phpMyAdmin logo image

How often do you backup your mySQL database? Does the idea fill you with horror? Or do you think the “full backup” option at your ISP covers the database too?

If the answers are “not often enough, pretty much, and not so sure” then here's some help.

Watch this video to see just how fast ‘n easy it is to backup & ...

read more →
13