SQL RELATED ARTICLES

If you’d like to install WordPress on your cloud server, one of the easiest approaches is to work in shell. In this article we’ll explain how to: Create a new database in MYSQL Download the latest WordPress  package using WGET and TAR Later, in another post, I’ll cover actually installing WordPress. The first step is [...]

If you run your own LAMP stack there will probably come a day when you are ready to run more than one CMS driven website on the server. When the time comes, it becomes necessary to create a new database for each one. It is a very bad idea to provide anyone with root access [...]

Care to venture a guess as to how easy it is to launch a fresh installation of the Drupal CMS? Would you guess 50, 25 or 12 steps? How about 8 steps? Believe it or not, that’s right. In this Rackspace Recipe we will review just how easy it is. This tutorial assumes you’re working [...]

In this Rackspace Recipe we’re going to map out the process for installing LAMP (Linux Apache MySQL PHP) on an Ubuntu server. This will all be done from the command prompt or shell, as it is called in Linux and Unix. If you are attempting to connect to a Linux machine from Windows I suggest [...]

I was very fortunate to have learned the concept of data normalization around the same time I learned to build a simple web page. Theoretically I could design a fully normalized relational database early in my career but in practice, things were a little messier than that. This was mostly due to the fact my [...]

I was originally taught to build dynamic web pages with Coldfusion. If you are not familiar with Coldfusion (CF), its key strengths include functions that make it very simple to connect with a database and work with result sets. Functions like <CFQUERY> and <CFOUTPUT> bundle low level, common commands and make them easy to understand [...]