This guide will presume you have already created a table in your CatN vCluster database, or have existing tables created by a CMS install or something similar.
For a guide to manually creating a database table, have a look here.
Data types MySQL – phpMyadmin
When creating a table in phpMyAdmin, there is a long list of data types available when naming your fields.
Here is a brief explanation of the different data types available and what the names mean!
Text Types
| CHAR() | A string of fixed length, with a maximum length of 255 characters. |
| VARCHAR() | A string that can vary in length, with a maximum length of 255 characters. Adding a number in the brackets will determine the string length to be used in the column. |
Database Keys – phpMyadmin
Databases use keys to store, sort and retrieve records efficiently and quickly. There are many types of keys: primary keys, candidate keys, and foreign keys, in this guide I’ll quickly go over the differences.
Primary Key
A Primary Key is a unique identifier for a record in a database table. It is important as it enables access to a particular record to be very quick, based on a single record using a single unique identifier, and by definition there can only be one instance of the Primary Key for each record.
Commonly used Primary Keys are driver license number, telephone number, or an automatically incrementing user or ID number. See this guide for use of an ID number. Read the rest of this entry »
Creating a table in phpMyadmin
Login to the CatN Control Panel and access phpMyadmin. A guide for this is available here.
Inside the phpMyadmin dashboard the left sidebar displays the name of your database, and displays any tables created inside this database. If you have just purchased your vCluster and have not installed any CMS’s, this list will be empty.
Now if you want to add new tables to the empty database, you simply click the database name in the sidebar to be taken to the add table form. Read the rest of this entry »
Log in to phpmyadmin
Logging in to phpMyAdmin is simple, and is possible through two locations of the CatN control panel.
The first thing to do is head over CatN.com, and login to the Control Panel.
You can either access phpMyadmin through the database section of a specific vCluster, or use the Tools sidebar menu and specify the vCluster in the following menu. Read the rest of this entry »
SSH key pair passphrases
Passphrases are important for protecting the vital private part of your SSH key pair.
This is the part that unlocks, and re-locks the encrypted data as it is received and sent, so if compromised is a serious security risk! For this reason we always recommend adding a passphrase to you SSH key pair when generating.
For generating an SSH key pair in Mac OSX, go here.
For generating an SSH key pair in Windows, go here. Read the rest of this entry »
Why do we use SSH instead of telnet?
Telnet (Terminal Network) is a protocol that commonly provides a virtual text-based command line interface at a remote location.
Telnet clients (the software that implements the telnet protocol) are built into virtually every operating system available, and if not available natively, there are many options available for download, such as PuTTY, AbsoluteTelnet, and TeraTerm. It is worth noting that these clients do not only offer telnet implementation, but usually also offer at least SSH implementation as well.
Read the rest of this entry »
Generating an SSH key (Windows)
This guide ois for generating an SSH key using the PuTTY ss client that must be donwloaded before use. To generate an SSH key in Mac OSX view this guide.
In Windows a couple of light weight applications are required, as the windows command prompt does not support ssh natively. Read the rest of this entry »
Generating an SSH key (Mac OSX)
I have covered the topic of adding SSH keys to the CatN Control Panel in a previous guide, but this guide is specifically for generating an SSH key, not only for use with your vCluster.
The process differs between Mac OSX and Windows, and the Windows command prompt does not support SSH natively and must provide on a third party solution. Please note, if you have already know and have recorded your SSH key, then this guide is not for you!
Read the rest of this entry »
Setting up FileZilla as your FTP client
Our vCluster hosting supports FTP and SFTP, and although you can transfer files to your cluster through a terminal using SSH, it is often easier and more convenient to use a client with a GUI (Graphical user interface).
In fact, we recommend using a GUI FTP client in our CMS install guides, FileZilla for a local run solution.
Let’s have a look at why we think this is the best solution…
