Posts Tagged 'Linux'



Maintain Unmanaged VPS – Part 8: Update (Replace or Delete) MySQL Data

mysql update command image

Change repetitive db data with one single syntax command. Rather than manually find & alter each instance, isolate the lot & update multiple content.

There are some good plugins to do this with platforms like WordPress but, by way of an alternative method, this is handy when you want to swap or lose an identical content string across all the ...

read more →
0

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

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

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

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

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 16: Nginx Control Panel

nginx control panel image

You're migrating shared-to-VPS and want a GUI like cPanel? No you don't, not after you read this! What's more, you don't need one either …

When I first looked at unmanaged VPS options, as a Linux newbie, one thing that concerned me was to have a control panel. So I set up Ubuntu, tacked on familiar Apache, and added ...

read more →
9

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

Set Up Unmanaged VPS (4 Newbies) – Part 14: Tweak Nginx for WordPress – Pretty URLs & WP Super Cache

wordpress nginx image

For the blog platform WordPress to work properly with Nginx we need to tweak the web server configuration. This tutorial will enable both caching – integrating the WP Super Cache plugin – and activate pretty permalinks (FURLs, CURLs, all that!) with some simple rewrite rules.

OK, so you're a WordPress blogger. If you're not, move swiftly on. ...

read more →
36

Set Up Unmanaged VPS (4 Newbies) – Part 13: Serve Multiple Sites & Blogs with Virtual Hosts

web sites folder structure image

Now to add sites & blogs to our powerful web server, using vhost (virtual host) files and symlinks. We'll create a site file structure, add users with groups & permissions, tweak Nginx with FastCGI support and upload pages using SFTP.

OK, so we've got Nginx humming on our shiny new Linux ...

read more →
44
Page 5 of 7 «...34567