Found 8 results
Terminal keyboard shortcuts are very handy, no doubt about this, can save you a lot of time especially when your job is based on using on a daily basis the terminal window, being on your workstation or other remote terminals that you are interacting with. Mastering these terminal keys will clearly give you a huge advantage, as we said previously in terms of time and also productivity, on the same note we can also say that is a must to learn and use these shortcuts. Terminal Keyboard Cheatsheet Lets open now a terminal window and test all below keyboard shortcuts […]
Category: General | Published: 13/12/2018 | Updated: 16/12/2018Setup an SFTP Server on CentOS
Set up an SFTP server on CentOS is our next tutorial where we will guide you as always, step by step, how to build from scratch such a server. We all agree that an SFTP server can be quite handy or sometimes a must if for example one or more applications within our stack requires file transfer between different processing steps or maybe for backups. In this tutorial we will learn how to build an SFTP server on CentOS 7 and OpenSSH 7.4 and also providing you two authentication solutions, first one being based on using basic password authentication and […]
Category: General | Published: 08/11/2018 | Updated: 14/12/2018Copy MySQL table, the simple process of copying a MySQL database table will be now explained in this short tutorial. Quite often we need to check some new queries, features or simply we need perform some basic tests that can be very difficult or sometimes impossible to be taken on a live database table. Luckily MySQL can help us to copy a database table with or without indexes and triggers, a full table copy or we can simply take a simple table copy, just the data and nothing else. In this short tutorial we will guide you how to take […]
Category: MySQL | Published: 10/08/2018 | Updated: 08/11/2018In this tutorial called dump MySQL table and import we will learn how to export a single database table using mysqlpump utility instead of exporting an entire database and also we will guide you how to import a single database table using different methods. Exporting a single table can be very handy when you have to update or replace another database table that is not part of a cluster or maybe you simply need it for your development environment to perform some quick changes or various tests. In this example we will use MySQL 5.7 and MySQL Client (CLI) based […]
Category: MySQL | Published: 08/08/2018 | Updated: 23/04/2019In this tutorial called create MySQL slave by cloning we’ll try to guide you through a very detailed but in the same time simple process to create a MySQL slave, also known as MySQL replica, by using a fresh backup taken from an existing MySQL server referred here as MySQL master server. Assuming that our master database is 11TB large we’ll have to copy its data content from US, where the master server is located to another server located in a UK data centre, not quite an easy task with this amount of data or without using a costly commercial […]
Category: MySQL | Published: 06/07/2018 | Updated: 05/11/2018Generate SSH Key – Linux, Mac and Windows
In this quick tutorial, Generate SSH Key, we will learn more exactly how to generate a SSH Key in Linux or Mac using a terminal window and also in Windows using Putty. Before we start our little journey we should be clear about one thing, all SSH Keys consists of two parts, a Private Key and a Public Key. In this article we’ll generate both these keys and we’ll learn the importance but also the difference between these two. What is a Pivate Key As we said in our introduction a SSH Key contains a Private Key and a Public […]
Category: Security | Published: 09/02/2018 | Updated: 05/11/2018